Re: proxy account

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 11/14/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Thu, 14 Nov 2002 06:02:28 -0700

Another option is to create a stored procedure that executes
the xp_cmdshell command and if the stored procedure is owned
by dbo and the database is owned by sa, you could grant
permissions on this stored procedure instead of on
xp_cmdshell.

-Sue

On Thu, 14 Nov 2002 02:42:04 -0800, "Sarma UV"
<sarmauv@yahoo.com> wrote:

>Its like any other stored procedure access. Use grant exce
>on xp_cmdshell to public / user
>
>>-----Original Message-----
>>How do I grant a user access to the xp_cmdshell proc
>>without giving them sysadmin server role permissions? I
>>found documentation telling me about the
>>xp_sqlagent_proxy_account proc but no explaination of how
>>to use it. Does anyone know how this proxy account could
>>be set up and utilized, or better yet, an alternative way
>>of giving a user access to the cmdshell without sysadmin
>>permissions? I'm not even comfortable with a user having
>>cmd line access. How does everyone else handle this?
>>.
>>

Relevant Pages

  • Re: Logon failed for user ". but only for membership tables in same database that other request wor
    ... I was able to log on to computer b and execute the stored procedure. ... was no error after I corrected the permissions for the user. ... I can access the stored procedure but I can not use membership.validateuser. ... You may use the GRANT statement to grant the EXECUTE permission for a ...
    (microsoft.public.sqlserver.security)
  • Re: SET IDENTITY_INSERT Privileges?
    ... on the stored procedure to get around this. ... stored procedure and the user has execute permissions on the ... How do I grant permission to a SET Statement?? ...
    (microsoft.public.sqlserver.security)
  • Re: Exec permissions on Stored Procedure
    ... If I grant EXEC permissions on a Stored Procedure to a Domain User ... shouldn't they be able to Execute that stored procedure reguardless if they ...
    (microsoft.public.sqlserver.security)
  • Re: Help understanding Stored proc Level Secuirty?
    ... Permissions on objects accessed by ... you can grant SELECT on tables/views ... > fixed it by setting my Stored Procedure Level Permissions to Role: ... do I have to do anything different with the Stored Proc ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 Database Security
    ... You can grant an EXECUTE permission on the stored proceduers on database ... stored procedure, then you'll have to grant SELECT/UPDATE/DELETE/UPDATE ... I have to grant the appropriate permissions ...
    (microsoft.public.sqlserver.security)