Managing Permissions

Grant or revoke command permissions or object permissions to or from users, groups, or roles.

Permission	Grantee or Object	Links
Create Command Permissions	You can grant or revoke these create commands to or from users, groups, or roles: create default create function create procedure create role create table create view	Setting Command Permissions for a Group Setting Command Permissions for a Role Setting Command Permissions for a User
Object Permissions – Owners	You can grant or revoke object permissions to or from a user, group, or role.	Granting Object Permissions to a Role Revoking Object Permissions from a Role Granting Object Permission to a User Revoking Object Permissions from a User Granting Object Permissions to a Group Revoking Object Permission from a Group
Object Permissions – Object	For tables, you can set these permissions: select insert delete update references transfer truncate table update statistics delete statistics	Setting Table or Column Permissions
	For stored procedures, scalar functions and extended stored procedures, you can grant or revoke execute permission.	Granting Execute Permission on an Extended Stored Procedure Revoking Execute Permission on an Extended Stored Procedure Granting Execute Permission on a Scalar Function Revoking Execute Permission on a Scalar Function Granting Execute Permission on a Stored Procedure Revoking Execute Permission on a Stored Procedure
	For encryption keys, you can grant or revoke execute permission.	Granting Encryption Permissions to Roles, Users and Groups.
	For views, you can set these permissions: select insert delete update	Granting Permissions on Views Revoking Permissins on Views
	For precomputed results, you can grant or revoke execute permission.	Granting Permissions Revoking Permissions Granting Precomputed Result Set Permissions to a Specific User Revoking Precomputed Result Set Permissions to a Specific Use