The flashcards below were created by user
on FreezingBlue Flashcards.
Which init parameter controls case sensitive passwords, what are the options?
How is a password stored?
Case sensitve, SEC_CASE_SENSITIVE_LOGON just ignores the case
How can one tell what version of a password is being used?
PASSWORD_VERSIONS column in DBA_USERS
How is orapwd set to ignore the case of the password?
What is the default ignorecase parameter in orapwd?
Which view can help find accounts that user defaul passwords?
If an account is imported into 11G from a previous release, what happens to the password?
It remains case insensitive
What is the syntax to create an Encrypted Tablespace?
- CREATE TABLESPACE tbs_name
- DATAFILE '/path/filename' SIZE xx
- ENCRYPTION [USING 'EncMethod']
- DEFAULT STORAGE(ENCRYPT);
What is the default encryption method in Encrypted Tablespace?
Where is the master encryption key stored for Encrypted Tablespace?
When the Oracle Wallet is opened, how lond does it say open for?
Until the database is shutdown or it's explicitly closed.
What are the restictions in Encrypted Tablespace?
- Cannot encrypt a tablespace using ALTER TABLESPACE
- Subject to restrictions in tablespace transporting
- When recovering, the Oracle Wallet must be opened after database mount and before database open.
Where is the Oracle Wallet location defined?
ENCRYPTION_WALLET_LOCATION in sqlnet.ora
What is the default location for the Oracle Wallet?
What is the command to open the Oracle Wallet?
ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY "myPassword";
Which view shows if a tablespace is encrypted?
ENCRYPT column in DBA|USER_TABLESPACES
Which common PL/ SQL utility packages are designed to enable database users to access network services from within the database?
UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP, UTL_INADDR
Which Packages control the ACLs?
DBMS_NETWORK_ACL_ADMIN and DBMS_NETWORK_ACL_UTILITY
What is used to create an ACL?
What is PRINCIPLE in DBMS_NETWORK_ACL_ADMIN.CREATE_ACL?
The first user account or role being granted or denied permissions
What is PIVILEGE in DBMS_NETWORK_ACL_ADMIN.CREATE_ACL?
- CONNECT - UTL_TCP, UTL_SMTP, UTL_MAIL and UTL_HTTP
- RESOLVE - UTL_INADDR (name/IP resolution)
How is a user/role added to an ACL?
How is a user/role removed from an ACL?
How is an ACL dropped?
How is a host assigned to an ACL?
- ( acl = > 'file_name.xml',
- host = > 'network_host',
- lower_port = > null | port_number,
- upper_port = > null | port_number);
In a Oracle Password, which special characters do not have to be encapsulated in quotes?
What are the options for SEC_PROTOCOL_ERROR_TRACE_ACTION?
What are the options for SEC_PROTOCOL_ERROR_FURTHER_ACTION?
- CONTINUE (Default)
- DELAY, n (secs)
Which parameter limits logon attempts for a client session?
What is the default for parameter AUDIT_TRAIL? To where are entries written?