Examine the command:
SQL>ALTER USR skd ACCOUNT LOCK;
Which two statements are true after the command is executed? (Choose two.)
A.
The SKD user cannot log in to the database instance
B.
The objects owned by the SKD user are not accessible to any user
C.
The other users can access the objects owned by the SKD user, on which they have access
D.
The password for the SKD user expires and the user is forced to change the password at the next
log in
— lock an account:
ALTER USER ACCOUNT LOCK;
— unlock an account:
ALTER USER ACCOUNT UNLOCK;
1. lock the user scott
sys @ TEST0910> alter user scott account lock;
User altered.
2. can not connect to the database, A is correct.
The next time you connect and unable to connect to the database, but the password has not expired, and no mandatory password change, D is wrong.
sys @ TEST0910> conn scott / tiger
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
3. using the SYS user can access to scott user’s table, C is correct, B is wrong
sys @ TEST0910> conn / as sysdba
Connected.
sys @ TEST0910> select * from scott.emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
———- ———- ——— ———- ———– ——– ———- ———-
7369 SMITH CLERK 7902 17-DEC-80 800 20
7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30