一当把同义词的权限给别的用户时，实际上给的是同义词所基于的表的权限。

二赋视图的权限时，只是视图的，没有基表的。

一同义词

conn song/song

create synonym syn_t for song.t_table;

conn user1/user1

SQL> select * from syn_t;

select * from syn_t

*

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> select * from dba_tab_privs where grantee='USER1';

no rows selected

SQL> conn song/song

Connected.

SQL> grant select on syn_t to user1;

Grant succeeded.

SQL> set line 200

SQL> select grantee ,owner,table_name from dba_tab_privs where grantee='USER1';

GRANTEE OWNER TABLE_NAME

------------------------------ ------------------------------ ------------------------------

USER1 SONG T_TABLE

二视图

SQL> conn song/song

Connected.

SQL>

SQL> set line 200

SQL> select view_name,text from user_views;

VIEW_NAME TEXT

------------------------------ --------------------------------------------------------------------------------

VIEW_T select "OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID","DATA_OBJECT_ID","OBJE

V_TT_TABLE select "ID" from tt_table

grant select on v_tt_table to user1;

SQL> conn user1/user1

Connected.

SQL> select count(*) from song.v_tt_table;

COUNT(*)

----------

0

SQL> select count(*) from song.tt_table;

select count(*) from song.tt_table

*

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> conn song/song

Connected.

SQL> select grantee ,owner,table_name from dba_tab_privs where grantee='USER1';

GRANTEE OWNER TABLE_NAME

------------------------------ ------------------------------ ------------------------------

USER1 SONG T_TABLE

USER1 SONG V_TT_TABLE

by song

ITPub博客

赋同义词权限

最新文章