Two types of permissions exist for objects:
Object access permissions – For using the commands that access database objects. For more information, see “Granting and revoking object access permissions”.
Object creation permissions – For creating objects. They can be granted only by a System Administrator or a Database Owner. For more information, see “Granting and revoking object creation permissions”.
Both types of permissions are controlled with the grant and revoke commands.
Each database has its own independent protection system. Having permission to use a certain command in one database does not give you permission to use that command in other databases.
