GRANT Examples
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;
Last modified date: 11/09/2022