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 |
What are the minimum parameters should exist in the parameter file (init.ora) ?
How can you Enforce Refrencial Integrity in snapshots ?
How to prevent unauthorized use of privileges granted to a Role ?
How can we reduce the network traffic ?
What are the various type of snapshots ?
What dynamic data replication ?
What are the different Levels of Auditing ?
What are the roles and user accounts created automatically with the database ?
How can we specify the Archived log file name format and destination ?
What is a trace file and how is it created ?
Differentiate simple and complex, snapshots ?
What are the use of Roles ?