Partilhar via

How to: Grant Permissions on a Stored Procedure (SQL Server Management Studio)

  • Artigo

This topic describes how to grant permissions on a stored procedure by using Object Explorer in SQL Server Management Studio. You can grant permissions to an existing user, database role, or application role in the database.

Procedures

To grant permissions on a stored procedure

  1. In Object Explorer, connect to an instance of SQL Server 2005 Database Engine and then expand that instance.

  2. Expand Databases, expand the database in which the stored procedure belongs, and then expand Programmability.

  3. Expand Stored Procedures, right-click the procedure to grant permissions on, and then click Properties.

  4. From Stored Procedure Properties, select the Permissions page.

  5. To grant permissions to a user, database role, or application role, click Add.

  6. In Select Users or Roles, click Object Types to add or clear the users and roles you want.

  7. In the Explicit Permissions grid, select the permissions to grant to the specified user or role. For a description of the permissions, see Permissions.

    Selecting Grant indicates the grantee will be given the specified permission. Selecting Grant With indicates that the grantee will also be able to grant the specified permission to other principals.

Note

You cannot use SQL Server Management Studio to grant permissions on system stored procedures or system functions. Use GRANT Object Permissions instead.

See Also

Concepts

Covering/Implied Permissions
Permissions Hierarchy
Permissions

Other Resources

Stored Procedure How-to Topics

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

14 April 2006
New content:
  • Added the note that states SQL Server Management Studio cannot be used to grant permissions on system stored procedures or system functions.