--1)创建测试用户 user1,user2,user3,并给user2和user3赋创建同义词的权限----------------------------------dba
-- Create the user
create user user1
identified by user1;
-- Grant/Revoke role privileges
grant connect to user1 with admin option;
grant resource to user1 with admin option;
-- Create the user
create user user2
identified by user2;
-- Grant/Revoke role privileges
grant connect to user2 with admin option;
grant resource to user2 with admin option;
-- Grant/Revoke system privileges
grant create synonym to USER2 with admin option;--add
-- Create the user
create user user3
identified by user3;
-- Grant/Revoke role privileges
grant connect to user3 with admin option;
grant resource to user3 with admin option;
-- Grant/Revoke system privileges
grant create synonym to