Re: Permission Problems for Newbies

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 06:28:42 -0600

1. Users can execute sp_helptext to view the text of stored
procedures.
2. Not directly. You could encyrpt all but the one stored
procedure
3. One option is to have the user own the job but they will
then be able to execute the job as well.

-Sue

On Wed, 22 Sep 2004 12:19:14 +0800, "Nobody"
<nobody@nospam.com> wrote:

>How can I:
>
>1. Grant a user for viewing all store procedure on a database without modify
>or execute
>
>2. Grant the user permission to view one store procedure on a database but
>not the other SPs
>
>3. Job history: Can I grant the user permission to view job content and/or
>history on a particular job but not others
>
>Thanks.
>

Relevant Pages

  • Re: Grant Execute right to the group of users
    ... Below is a script that will grant execute permissions to the specified role ... on all user procedures in the current database. ... > How could I grant the execute right to all stored procedures in a database for a group of users? ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored Procedures in the Master Database
    ... GRANTS must be done in the local database. ... The GRANT or the EXECUTE? ... >>> I have a stored procedure that I want to make available ...
    (microsoft.public.sqlserver.security)
  • Re: Cross-database execution permissions with certificates and sch
    ... activated user cannot access objects in other schemas in this database. ... injection is defended against, however, the threat exists anywhere EXECUTE ... CREATE USER dispatcher ... the certificate is a trusted authenticator because you granted AUTHENTICATE ...
    (microsoft.public.sqlserver.security)
  • Re: Execute Persmission denied on object sp_OACreate
    ... SQL Server doesn't check permissions on indirectly referenced objects as ... You can prevent ad-hoc execution of powerful master database procs while ... >I have a user who has execute permissions on a store procedure in a>database> which in turns executes 4 stored procedures in the master database. ...
    (microsoft.public.sqlserver.security)
  • Re: SQLCE performance from .NET CF v2.0
    ... Please remember when bulk inserting is being executed against SQL CE, ... > local database functionality. ... > database technology and I am considering switching to SQLCE at the same ... > execute the prepared statement again. ...
    (microsoft.public.dotnet.framework.compactframework)