What are roles ? How can we implement roles ?
Answers were Sorted based on User's Feedback
Answer / priya reddy
If a user wants to give some privileges to
another user or a group of users then they will create role
and they give this role to the users.let the privileges
be 'insert' and 'update' on 'emp' table then instead of
specifying them by their names they will create role which
inturn includes these methods. this role is further given
to the users.
If in futher if he wants to remove some
privilege given to the users, he can just alter the role
and remove that particular privilege such as he can remove
update from this created role..
Later the users cant do updations on that emp
table.but still can insert the values into that table.
Hence Roles are the easiest way to grant and
manage common privileges needed by different groups of
database users.Creating roles and assign each role to group
of users will simplify the job of assigning privileges to
individual users.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / kalaba
roles are a set of privilages that are been set to each
user profiles. v can create a default role and use the same
to a number of users.
Is This Answer Correct ? | 6 Yes | 2 No |
What are the different Levels of Auditing ?
How can you Enforce Refrencial Integrity in snapshots ?
What are the roles and user accounts created automatically with the database ?
what is the step for rmanbackup?
How can we specify the Archived log file name format and destination ?
What is the use of ANALYZE command ?
How can you enable automatic archiving ?
What is a trace file and how is it created ?
What is Privilege Auditing ?
What is Object Auditing ?
When will the data in the snapshot log be used ?
What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?