SQL Error 229.

From: Peter The Spate (anonymous_at_discussions.microsoft.com)
Date: 09/21/04 

Date: Tue, 21 Sep 2004 09:08:21 -0700

I would look at this in two ways,

1. What user id is executing the applet
2. What security permissions has the sp.

Here are two likely scenarios
1. The applet is being started by an Server administrator
account, that you have the builtin administrators set up
as System administrators in your SQL Server, therefore it
has permission to do just about anything.

You can test this out by using the profiler to see what
user id is executing the sp.

2. You have not put any security permission on your sp, or
the applet has connection code built into it that allows
access to it, either through nt administrator or SQL
Server security, again the best way is try it with the
profiler.

Peter

"I'm just preparing my impromptu remarks."
Winston Churchill

>-----Original Message-----
>Hi,
>
>I am trying to understand a problem that occurs on two
>nodes that were upgraded from 6.5 to 7 using the wizard.
I
>now know how to resolve this particular problem, but i
was
>wondering whether I had a larger problem with our
upgraded
>nodes as on a fresh SQL 7 installation the error does not
>occur?? The nodes that error are running NT4 6a, SQL 7 SP3
>
>The sequence of events is as follows:
>
>Java applet invokes an SP call, which updates some data
>using a cursor and returns a data structure back to the
>applet. The SP does not have any explicit permissions
>granted for this purpose and I can appreciate why the
call
>should fail.
>
>Firstly, could someone tell me why this does not fail on
>the fresh SQL 7 installations?
>
>Secondly, I have found another call from the applet using
>a SP that again does not have any permissions granted.
Can
>someone tell me why this call should work?
>
>As I said, if i grant the appropriate permissions for
that
>user, the problem goes away. However, I am concerned that
>other less visible instances of this problem may occur.
>
>Sorry for going on a bit, and I hope someone can point me
>in the right direction.
>
>Regards,
>
>Gary
>.
>

Relevant Pages

  • Re: Security restrictions in signed applets
    ... prompted to grant extra permissions? ... When I load the applet in a web browser I get a security warning pop-up ...
    (comp.lang.java.programmer)
  • Javaspaces Applet Help
    ... I don't know if there are any JavaSpaces experts on this group, ... Where runjs.jsp simply contains the appropriate applet tag and the ... Reluctantly (I'd rather not change default permissions for Java ... public class HelloWorldClient extends Applet ...
    (comp.lang.java.programmer)
  • Re: .NET Applet
    ... the first thing I would do is check to see if the framework is ... configured on each of the machines with the appropriate permissions to run ... You have to go to the Framework Configuration utility ... given that the applet runs. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Permission for Tabs in Active Directory
    ... Once you delegate those permissions to your trustee group you ... There is an applet that has a UI that basically looks like the "Terminal ... Services Profile" tab in ADUC. ... I'm looking to Delegate permission for my Active Directory domain down to ...
    (microsoft.public.windows.server.active_directory)
  • RE: Lost all security permissions.
    ... After all above every folder and file got back all permissions and I was ... Microsoft Global Technical Support Center ... | Subject: RE: Lost all security permissions. ...
    (microsoft.public.windows.server.general)
Quantcast