What are Roles ?
Answers were Sorted based on User's Feedback
Answer / 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;
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / pavan_1981
roles are virtual and are group of privelages.privelages
can be assined to the roles just as we do to users.they can
also be password protected.
Is This Answer Correct ? | 1 Yes | 0 No |
How to prevent unauthorized use of privileges granted to a Role ?
How can we reduce the network traffic ?
What are the different Levels of Auditing ?
What are the database administrators utilities avaliable ?
What is Tablespace Quota ?
What dynamic data replication ?
How will you enforce security using stored procedures ?
what is the step for rmanbackup?
What are the benefits of distributed options in databases ?
What are the roles and user accounts created automatically with the database ?
What is Privilege Auditing ?
What are the various type of snapshots ?