1z0-116 Exam Dumps - Oracle Database Security Administration

to authenticate externally Identified users locally

to authenticate nonprivllegcd database users locally

to authenticate administrative privileged users remotely

to authenticate externally Identified users remotely

to authenticate nonprivileged database users remotely

to authenticate administrative privileged users locally

System privileges override command rules.

If a command rule's associated rule set evaluation results In an error, the command is not allowed to execute.

A command can have only one command rule that applies to it.

For DML statement command rules, you can specify a wildcard for the object owner.

If a command rule's associated rule set Is disabled, then the rule set evaluates to true.

For DML statement command rules, you can specify a wildcard for the object name.

Object privileges override command rules.

ALTER DATABASE DICTIONARY REKEY CREDENTIALS;

SELECT * FROM DBA_OBJECTS;

SELECT * FROM DBA_TABLESPACES WHERE ENCRYPTED = 'YES*;

ADMINISTER KEY MANAGEMENT SET KFYSTOBF OPEN IDENTIFIED BY password:

ALTER SYSTEM FLUSH PASSWORDFILE_METADATA_CACHE;

ALTER TABLESPACE APPDATA ENCRYPTION OFFLINE ENCRYPT;

Grant become user to dbai.

Grant sysoper to both users.

Run d3ms_macadm.authorize_datapump_user procedure granting dbai privileges to impdp and expdp utilities.

Grant imp_full_database and exp_full_database to dbai and dba2.

Run dbms_macadm.authobize_datapump_useb procedure granting dba2 privileges to impdp and expdp utilities.

Grant become user to dba2.

Grant sysdba to both users.

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 12a in the sqlnet.ora of the new database home

Client net. allowed_lLOGON_VERSION_client must be set to a lower value than the server

SQLNET.ALLOWED LOGON. VEBSION .SERVER.

SQLNET.ALLOWED_LOGON_VERSION_client = 8 in the sqlnec.ora file of the client application.

SQLNET.ALLOWED_LOGON_VERSION_sebveb = 8 In the aqlnec.ora of the new database homo.