Oracle Database Administration from Zero to Hero - Managing User Privileges (Part 1 of 2)

This lecture covers user privileges in Oracle databases, focusing on system and object privileges. It explains how these privileges allow users to perform specific actions and how they can be granted or revoked. The lecture provides examples of system privileges like CREATE TABLE and ALTER ANY TABLE, and discusses the use of the GRANT and REVOKE statements. It also touches on the ALL PRIVILEGE shortcut and the importance of managing privileges carefully to maintain database security.

What are the two main categories of user privileges in Oracle databases?

• Table and View Privileges

• Administrative and User Privileges

• Database and Schema Privileges

• System and Object Privileges

Which privilege allows a user to create a table in any schema?

• DROP TABLE

• ALTER TABLE

• CREATE ANY TABLE

• CREATE TABLE

Who can grant object privileges in Oracle databases?

• Only the database administrator

• Any user with system privileges

• The owner of the object or an administrator

• Any user with object privileges

What is the purpose of the ANY clause in system privileges?

• To revoke privileges from any user

• To restrict privileges to specific users

• To allow privileges on any object in the database

• To grant privileges only to administrators

What is the syntax for granting a system privilege to a user?

• GRANT privilege TO user

• REVOKE privilege FROM user

• ALTER privilege FOR user

• CREATE privilege FOR user

What does the ALL PRIVILEGE shortcut exclude?

• DROP ANY TABLE

• ALTER ANY TABLE

• CREATE ANY TABLE

• SELECT ANY DICTIONARY

What happens if the GRANT statement is used with a non-existent user?

• The statement fails

• The user is created with the provided password

• The privilege is not granted

• The database is locked

What is the effect of a successful REVOKE statement?

• It is delayed until the next session

• It requires a database restart

• It takes effect immediately

• It only affects new sessions

Which users can grant system privileges with the admin option?

• Only SYS users

• Users with the DBA role

• Users granted specific privileges with the admin option

• Any user with object privileges

What is the recommended practice instead of granting ALL PRIVILEGE?

• Grant only to administrators

• Avoid granting privileges

• Grant individual privileges

• Use roles