Answer / pavan_1981

roles are group of previlages.
for example say there are 100 clerks in the company.they
all need some privilages to do their work.instead of
granting each clerk all the privilages,we create a role
called clerk and assign it to all 100 employees.in this way
we need to assign only a role to all the 100 employees
instead of granting all the privilages that belong to a
role clerk to each of the hundred employees.similarly if we
need to revoke or grant additional privilages to clerk we
can d0 that just by granting it or revokng it from the role
instead of doing it from or to 100 employees.
advantages:easier to use and maintain the privelages.

Answer / dinu

role is set of previlages
by assgning a role to a group is easier for a DBA to manage
the users, previlages. instead of assigning previlage them
separately creating a role is easier

Answer / a.brahmam

ROLE:-Role is nothing but the collection of either system privileges or object privileges.
Role is giving to system privileges at a time no.of users

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

3 Answers  

---

What are the minimum parameters should exist in the parameter file (init.ora) ?

1 Answers  

---

What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?

1 Answers  

---

What are the options available to refresh snapshots ?

2 Answers  

---

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

2 Answers  

---

What is user Account in Oracle database ?

2 Answers  

---

When will the data in the snapshot log be used ?

2 Answers  

---

What is the use of ANALYZE command ?

3 Answers  

---

What is Privilege Auditing ?

1 Answers  

---

What are roles ? How can we implement roles ?

2 Answers  

---

What are the use of Roles ?

3 Answers  

---

What is snapshots ?

2 Answers  

---