Administering User Security

Posted on
Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone

These questions are derived from the Self Test Software Practice Test for 1Z0-042 – Oracle Database 10g: Administration I.

 

Objective: Administering User Security
SubObjective: Create and manage database user accounts

 

Item Number: 1Z0-042.6.1.1
Multiple Answer, Multiple Choice

 

John is a database administrator at GlobeComm Corporation. John has been assigned the task of creating users. He issues the following statements to create a user BARRY and grant privileges to the user:

 

SQL> CREATE USER BARRY IDENTIFIED BY PASSWORD
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA 2M ON PROD
PASSWORD EXPIRE
ACCOUNT LOCK;
SQL> GRANT CREATE SESSION, CREATE TABLE TO BARRY;

 

Which statements correctly describe the user BARRY? (Choose all that apply.)

 

 

  1. The password assigned to BARRY will never expire.
  2. BARRY can create a table in the USERS tablespace.
  3. BARRY cannot create a table in the USERS tablespace.
  4. BARRY does not have privileges on the TEMP tablespace.
  5. BARRY cannot access his account without the intervention of the DBA.

 

Answer:
C. BARRY cannot create a table in the USERS tablespace.
E. BARRY cannot access his account without the intervention of the DBA.

 

Tutorial:
In this scenario, BARRY cannot create a table in the USERS tablespace and BARRY cannot access his account without the intervention of the DBA. The CREATE USER statement creates a user BARRY and assigns him the password, PASSWORD. After the first successful login, the PASSWORD EXPIRE clause will expire the password, and BARRY will be prompted to change his password. The ACCOUNT LOCK clause locks the user account immediately upon creation, and BARRY cannot access his account unless the DBA unlocks his account. BARRY cannot create a table in the USERS tablespace because BARRY has not been given any quota on the USERS tablespace. BARRY does not have privileges on the TEMP tablespace because he has not been given any quota on the TEMP tablespace.

 

The option stating that BARRY does not have privileges on the TEMP tablespace is incorrect. It is not necessary to explicitly define a quota for users to use the temporary tablespace.

 

The option stating that the password assigned to BARRY will never expire is incorrect. The password assigned to BARRY will expire. In this scenario, the PASSWORD EXPIRE clause specifies that the password will expire. After an initial successful login, the password will expire, and BARRY will be prompted to change his password.

 

The option stating that BARRY can create a table in the USERS tablespace is incorrect because BARRY has not been assigned any quota on the USERS tablespace.

 

Reference:
1. Oracle University – Oracle Database 10g: Administration Workshop I – Chapter 9: Administering User Security – System Privileges
D17090GC20
Edition 2.0
August 2005
D21638

 

2. Oracle Database SQL Reference 10g Release 2 (10.2)
Part Number B14200-02
Chapter: 17 SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT
Topic: CREATE USER
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_8003.htm#i2065278

 

3. Oracle Database SQL Reference 10g Release 2 (10.2)
Part Number B14200-02
Chapter: 18 SQL Statements: DROP SEQUENCE to ROLLBACK
Topic: GRANT

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9013.htm#i2155015

Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment: