Database---Authorization: Grant && revoke

The database administrator can grant users permission to manipulate data

Grank: Granting Permissions

Grank < permissions >[,< permissions ...]

on< Object Type >< Object name >[,< Object type >< object name ...]

To < users >[,< users;]

[with Grank OPTION]; -----A user who has access to some kind of permission can grant this permission to another user

For example:

Grank SELECT

On TABLE Student

to U1;

Grank all privileges-------All permissions

On TABLE Student,course

to U2,U3;

REVOKE: Reclaim permissions that have been granted

REVOKE < permissions >[,< permissions ...]

On < object type >< object name >[,< Object type >< object name; ...]

From < users >[,< users;] ... [cascade| RESTRICT];

Database---Authorization: Grant && revoke