You can control the following types of permissions with grant and revoke:
Object access permissions
Permission to select from functions
Permission to execute commands
Permission to execute dbcc commands
Permission to execute some set commands
Default permissions on system tables
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.
