grant select on table1 to cys.
这样cys就可以通过AMILDB.table1来使用。
或者
create public synonym syn_table1 for table1.
这样cys可以使用syn_table1来使用
这样cys就可以通过AMILDB.table1来使用。
或者
create public synonym syn_table1 for table1.
这样cys可以使用syn_table1来使用
但CYS在使用这些表时仍需加上前缀 AMIL。
CREATE ANY TABLE Create tables in any schema. The owner of the schema containing the table must have space quota on the tablespace to contain the table.
ALTER ANY TABLE Alter any table or view in the schema
BACKUP ANY TABLE Use the Export utility to incrementally export objects from the schema of other users
DELETE ANY TABLE Delete rows from tables, table partitions, or views in any schema
DROP ANY TABLE Drop or truncate tables or table partitions in any schema
INSERT ANY TABLE Insert rows into tables and views in any schema
LOCK ANY TABLE Lock tables and views in any schema
UPDATE ANY TABLE Update rows in tables and views in any schema
SELECT ANY TABLE Query tables, views, or snapshots in any schema
2。再以cys登陆,创建同义词
例如:amil中有表table1,则
grant all on table1 to cys;
create synonym table1 for AMILDB.cys;
mywander(走不动了) :20
nashan(浪客剑心) :20
w_tsinghua() ;10