xp_cmdShell

From: Julie (anonymous_at_discussions.microsoft.com)
Date: 05/14/04 

Date: Fri, 14 May 2004 06:29:38 -0700

The following is cut from bol
"By default, only members of the sysadmin fixed server
role can execute this extended stored procedure. You may,
however, grant other users permission to execute this
stored procedure. "

J

>-----Original Message-----
>I have user with read permissions on my tables and
execute permission on my SP.
>
>In SP(owner is DBO) I update table(owner is DBO), and on
update the trigger is fired witch write some data into the
text file in my disk.
>
>I get an error message:
>EXECUTE permission denied on object 'xp_cmdshell',
database 'master', owner 'dbo'
>
>Why?
>I don't want that my read user has execute permission on
xp_cmdShell.
>I thought if he has execute permission for my sp, which
owner is DBO, that inside SP I can do anything.
>Is there any other way?
>
>thank you,
>Simon
>
>

Relevant Pages

  • Re: xp_cmdShell
    ... checkbox under SQL Server Agent properties --> Job ... System) and specify a Windows account for the SQL Agent proxy with the ... > I thought if he has execute permission for my sp, which owner is DBO, that ... If I set the execute permission for 'xp_cmdshell' to my read user I get the ...
    (microsoft.public.sqlserver.programming)
  • Change owner to sp_prueba
    ... I need to change the owner of a stored procedure called sp_prueba ... created by a user time ago. ... When I try to execute sp_changeobjectowner 'sp_prueba', dbo an error ...
    (microsoft.public.sqlserver)
  • Re:Stored Procedure Question
    ... When you execute a SP without any owner name by default ... SQL assumes it to be dbo. ... the stored procedure fire following query. ...
    (microsoft.public.sqlserver.security)
  • Re: NX bit versus standard permissions?
    ... Section is not a segment neither a page. ... Now, if the CPU has no way to enforce NX, the execute permission is ... x86 CPUs could *only* enforce ... Fortunately tools have been good about setting the execute bit in the code ...
    (comp.lang.asm.x86)
  • Re: Weird Permissions Problem With Includes
    ... Yes that is the weird thing, I gave read and execute permission to the ... PHP scripts are not executed. ... calling PHP scripts from the command line, cron jobs, etc. ...
    (comp.lang.php)