本文详细解析了在Oracle数据库中创建用户user1的过程，包括设置密码过期、解锁账号、授予登录权限及创建表权限，并分析了user1的具体权限范围，如登录数据库、授予他人创建表权限及首次登录必须更改密码等。
29、In one of your databases:
* The database default tablespace is EXAMPLE.
* Deferred_segment_creation is false.
Examine these commands:
SQL> create user user1 identified by oracle_4u password expire;
User created.
SQL> alter user user1 account unlock;
User altered.
SQL>grant create session to user1;
Grant succeeded.
SQL> grant create table to user1 with admin option;
Grant succeeded.
14、Which three are true?
A. user1 can log in to the database instance.
B. user1 can grant the create table privilege to other users.
C. user1 can create tables in the example tablespace.
D. user1 must change it’s password at first login.
E. user1 can create indexes in example tablespace.
Correct Answer: ABD
扫一扫
147
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
