Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews DB Oracle Interviews:Concepts and ArchitectureData AccessDatabase ArchitectureDatabase ManagementDatabase Security OracleDistributed ProcessingFlexfieldForms ReportsGeneral OracleMemory ManagementMTO-SAP Financial AccountingOCIOracle AOLOracle AROracle Backup RecoveryOracle D2KOracle DatabaseOracle Database DeveloperOracle DB OptimizationOracle DBAOracle DeveloperOracle ETLOracle Forms 3.0Oracle Forms 4.0Oracle GLOracle PL-SQLOracle RMANOracle ScenariosOracle SecurityOracle SQLOracle System ArchitectureOracle Technology Network (OTN)Programmatic ConstructsRAC (Real Application Clusters)SQL Plus
Copyright © 2018. All Rights Reserved
Oracle Security Interview Question:
What are roles? How can we implement roles?
Submitted by: AdministratorIf 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.