A.11. Chapter 11
Privileges can be grouped and assigned as a unit by using what database object?
Answer: A role can be used to group system and object privileges and assign them as a unit to database users.
When granting privileges with the GRANT statement, what does the clause WITH GRANT OPTION do?
Answer: The WITH GRANT OPTION clause allows the grantee to pass on the privilege to another database user.
DROP USER and CREATE SESSION are examples of what kind of privileges?
Answer: DROP USER and CREATE SESSION are examples of system privileges.
What is the name of the table, owned by the user SYS, that contains all audit records?
Answer: The table SYS.AUD$ contains all audit records.
Write a SQL statement that will create audit records when UPDATE statements ...
Get Oracle Database Foundations now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
