Exam 12: Security Management

A(n)____________________ privilege gives a user the ability to manage some part of the database system.

You can grant a privilege and add WITH ADMIN OPTION or WITH GRANT OPTION when granting to a role.

The syntax of DROP PROFILE is similar to the syntax for dropping a user in that it includes a(n)____________________ parameter.

Auditing commands are accepted but have no effect unless the AUDIT_TRAIL parameter is set to a value other than "NONE."

____ privileges are needed to create tables in a database.

When granting object privileges,the ____ can only be used to grant UPDATE,REFERENCES,and DELETE privileges.

The ____ privilege allows a user to log on to the database.

A(n)____________________ is simply the name for the calculated value of the weighted sum of the resources consumed by the user session.

After a user is created,you can change the initial settings using the ____________________ statement.

The act of revoking an object privilege ____.