Exam 12: Security Management

There is no command to alter a grant that has been given,so you must reissue the grant.

____ auditing audits types of SQL commands.

Very few privileges are given to ____________________ (all users).

A ____ is a named group of privileges that can be assigned to a user as a set rather than individually.

System privileges are more pinpointed than object privileges.

There are ____ password settings that you can set within a profile.

The default profile,named ____,has no limits on resources or database use.

When you plan to adjust resource limits in any Oracle 10g database,you must first change the initialization parameter named ____.

If the OS_AUTHENT_PREFIX is WIN,and the user's operating system logon name is SBAILEY,then the Oracle user name you create for SBAILEY should be named ____________________.

A(n)____ privilege gives a user the ability to perform certain tasks on specific tables or other objects that are owned by a schema.

You should click on the ____ tab of a user's property sheet (available in the Security Management section of the Enterprise Manager console)to change the user's password,default tablespace,account status,and profile,without writing any code.

The approach to security with roles,and particularly the CONNECT role,is known as a policy of ____.

The ____ user owns most of the tables needed to run the database,as well as the data dictionary views.

The ______________________________ privilege allows a user to insert rows into the EMPLOYEE table in the CLASSMATE schema.

Oracle10g allows a quota allocation on the TEMP tablespace;Oracle 9i did not.

To enforce password complexity you must use a combination of a function and a ____.

The ____________________ data dictionary view contains audit trail records generated by object auditing of nonexistent objects.

The ____ user is given the DBA role,which allows it to perform routine database administration tasks such as creating new users,monitoring database activities,and regulating database resources

SYSTEM can grant any system privilege to any other user.

Resources can be set to zero using the ____ statement.