本文深入探讨了数据库中用户的创建、解锁及权限授予过程，重点分析了CREATE SESSION、CREATE TABLE等权限的意义及其对用户操作的影响。同时，通过实例展示了用户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
转载于:https://blog.51cto.com/13854012/2152545
扫一扫
182
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
