Post reply

Stored Proc & Security Settings

  • December 4, 2002 at 3:33 am

    #80430

    Hi All

    I can't resolve this ,maybe you can ???

    Step one :

    create a stored proc in the master db as sa :

    code]

    Create procedure dbatest

    as

    eXEC master..xp_cmdshell '"dir /B *.*"'

    GO

    [/code]

    Step 2 : create a testuser

    grant the testuser exec on the stored proc

    step 3

    login as testuser and execute this

    then i get error message :

    Msg 50001, Level 1, State 50001

    xpsql.cpp: Error 997 from GetProxyAccount on line 472

    what is wrong ?

  • December 4, 2002 at 3:58 am

    #443038

    xp_cmdshell is a restricted command and can only be called by sysadmin/dbo users. If your testuser is non sysadmin then it does not have permissions to the command even by attempted proxy.

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply