Examples: Grant
1. Grant update privileges on the columns, empname and empaddress in the employee table to the users, joank and gerryr.
grant update(empname, empaddress)
on table employee
to joank, gerryr;
2. Enable any user to select data from the employee roster.
grant select on emp_roster to public;
3. Enable the accounting manager, rickr, complete access to salary information and to grant permissions to other users.
grant all on employee to rickr with grant option;
4. Enable any user to create a table constraint that references the employee roster.
grant references on emp_roster to public;