![]() Selecting Grant With indicates that the grantee will also be able to grant the specified permission to other principals. Selecting Grant indicates the grantee will be given the specified permission. For a description of the permissions, see Permissions (Database Engine). In the Explicit Permissions grid, select the permissions to grant to the specified user or role. ![]() Select the users or roles to whom permissions should be granted. Select Browse to display the list of users or roles. ![]() In Select Users or Roles, select Object Types to add or clear the users and roles you want. To grant permissions to a user, database role, or application role, select Search. In Object Explorer, connect to an instance of Database Engine and then expand that instance.Įxpand Databases, expand the database in which the procedure belongs, and then expand Programmability.Įxpand Stored Procedures, right-click the procedure to grant permissions on, and then select Properties.įrom Stored Procedure Properties, select the Permissions page. Use SQL Server Management Studio To grant permissions on a stored procedure For more information, see GRANT Object Permissions (Transact-SQL). Requires ALTER permission on the schema to which the procedure belongs, or CONTROL permission on the procedure. The grantor (or the principal specified with the AS option) must have either the permission itself with GRANT OPTION, or a higher permission that implies the permission being granted. You cannot use SQL Server Management Studio to grant permissions on system procedures or system functions. ![]() Permissions can be granted to an existing user, database role, or application role in the database. This article describes how to grant permissions on a stored procedure in SQL Server by using SQL Server Management Studio or Transact-SQL. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |