Topic : Privilege Management

Which view will show a list of privileges that are available for the current session to a user?


  • SESSION_PRIVS
  • DBA_SYS_PRIVS
  • DBA_COL_PRIVS
  • DBA_SESSION_PRIVS

Answer :

SESSION_PRIVS

Show Answer Discuss

It is very difficult to grant and manage common privileges needed by different groups of database users using roles.


  • TRUE
  • FALSE

Answer :

FALSE

Show Answer Discuss

What are the types of privileges?


Answer :

Oracle has two kinds of privileges :
System Privileges
Object Privileges

Show Answer Discuss

Name the four main object privileges used in the Oracle Database lOg?


Answer :

The four most common privileges are
Select
Insert
Update
Delete

Show Answer Discuss

What is the difference between system and object privileges?


Answer :

This statement when executed will display all the available system privileges such as Create Session; Drop User; Alter Database and so on.

Show Answer Discuss