oracle创建同义词授权,Oracle同义词赋权

--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 USER3 with admin option;--add

--2)登录user1，创建测试表，将查询权限赋给user2

----------------------------------user1

create table syn_test(syn_test char(1));

grant select on syn_test to user2;

--3)登录user2，创建同义词，测试查询权限

----------------------------------user2

-- Create the synonym

create or replace synonym syn_test

for USER1.syn_test;

select * from syn_test;--ok

select * from user1.syn_test;--ok

--4)登录user3，创建同义词，测试查询权限

----------------------------------user3

-- Create the synonym

create or replace synonym syn_test

for USER2.syn_test;

select * from syn_test;--ORA-00942:表或视图不存在

select * from user2.syn_test;--ORA-00942:表或视图不存在

--5)登录user2，给user3赋查询同义词权限

---------------------------------user2

grant select on syn_test to user3;--ORA-01031:权限不足