ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle Security
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question
What are roles ? How can we implement roles ?
 Question Submitted By :: Soni Sarma
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are roles ? How can we implement roles ?
Answer
# 1
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 ?    0 Yes 0 No
Priya Reddy
 
  Re: What are roles ? How can we implement roles ?
Answer
# 2
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 ?    0 Yes 0 No
Kalaba
 
 
 

 
 
 
Other Oracle Security Interview Questions
 
  Question Asked @ Answers
 
What dynamic data replication ?  1
What are the use of Roles ?  2
What are the different Levels of Auditing ?  1
How can you enable automatic archiving ?  2
What is default tablespace ?  2
What are the system resources that can be controlled through Profile ?  1
What are the responsibilities of a Database Administrator ?  1
What are Roles ?  1
What are the benefits of distributed options in databases ?  1
what is snapshot log ?  1
What is snapshots ?  1
What is user Account in Oracle database ?  1
What is a profile ?  1
What are the minimum parameters should exist in the parameter file (init.ora) ?  1
What is Statement Auditing ?  1
What are the roles and user accounts created automatically with the database ?  1
What are roles ? How can we implement roles ?  2
What is Tablespace Quota ?  1
What is Privilege Auditing ?  1
When will the data in the snapshot log be used ?  1
 
For more Oracle Security Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com