GRANT MSDN article
GRANT {permission} on {securable} TO {principal}
Use sp_helprotect to view permissions on a database-level securable.
Object owners can grant permissions on the objects they own.
Principals with CONTROL permission on a securable can grant permissions on that securable.
Grantees of CONTROL SERVER permission can grant any permission on any securable on the server.

Advertisements