1.Previous
3.Next

table (and other objects) to, or takes away a specified role with certain permissions to, specified groups or users of a database;;DENY: denies a specified permission to a security object.

For example: GRANT can be used to give privileges to user to do SELECT, INSERT, UPDATE and DELETE on a specific table or multiple tables.

The REVOKE command is used to take a privilege away (default) or revoking specific command like UPDATE or DELETE based on requirements.

Example

In the first example, GRANT gives privileges

1.Previous
3.Next