grant references 测试

sys@LS1>create user user1 identified by user1;

User created.

sys@LS1>grant dba to user1;

Grant succeeded.

sys@LS1>create user user2 identified by user2;

User created.

sys@LS1>grant dba to user2;

Grant succeeded.

sys@LS1>conn user1
Enter password:
Connected.
user1@LS1>create table tb1_user1 (id number);
Table created.

user1@LS1>conn user2
Enter password:
Connected.
user2@LS1>create table tb1_user2 (id number);
user2@LS1>insert into tb1_user2 values (1);

1 row created.

user2@LS1>commit;

Commit complete.

user2@LS1>select * from tb1_user2;

        ID
----------
         1

user2@LS1>alter table tb1_user2 add primary key(id);

Tab