Answer Posted / www.cdigital.com.pk

A Role is a named group of related privileges that can be
granted to the user. This method makes it easier to revoke
and maintain privileges. A user can have access several
roles and several ser can be assigned the same role. Role
is typically created for a database application.
You create a role with the create role command and then
grant the role to the user with the grant command as
following:

SQL> Create role update_role;

SQL> Grant update on EMP, DEPT to update_role;

Now you can grant this role to other users ACC1. Once this
is done and now ACC1 will be able to update the EMP and
DEPT tables in the SCOTT schema:

SQL> GRANT update_role TO ACC1;

If you wish to revoke a role from a user, simply use the
revoke command as following:

SQL> REVOKE update_role FROM ACC1;

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category