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;

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.

What is Object Auditing ?

2 Answers  

---

How can you enable automatic archiving ?

2 Answers  

---

What are the responsibilities of a Database Administrator ?

3 Answers  

---

What are the system resources that can be controlled through Profile ?

3 Answers  

---

What is a profile ?

2 Answers  

---

What are the various type of snapshots ?

3 Answers  

---

What is a trace file and how is it created ?

2 Answers  

---

How can we specify the Archived log file name format and destination ?

2 Answers  

---

What is Privilege Auditing ?

1 Answers  

---

What are the different Levels of Auditing ?

1 Answers  

---

What are the database administrators utilities avaliable ?

2 Answers  

---

When will the data in the snapshot log be used ?

2 Answers  

---