我需要帮助理解用户在创建指向其他(不同)模式对象的同义词时需要哪些授权/权限。
当我尝试以下操作时,出现了 ora-01031 不足的权限,所以显然我缺少并未能应用其他必要的权限。我已经尽力搜索了,但是没有找到与跨模式同义词有关的具体信息。
CREATE USER test IDENTIFIED BY pw DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
ALTER USER test IDENTIFIED BY pw;
GRANT CONNECT, RESOURCE TO test;
-- ... create a bunch of stuff in test...
CREATE USER READWRITE IDENTIFIED BY pw DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
ALTER USER READWRITE IDENTIFIED BY pw;
GRANT CONNECT, RESOURCE TO READWRITE;
GRANT SELECT ON GDACS.FIXALARMS TO PUBLIC;
GRANT UPDATE, INSERT ON GDACS.FIXALARMS TO READWRITE;
CONNECT READWRITE/pw;
CREATE SYNONYM FIXALARMS for test.FIXALARMS;
ORA-01031 insufficient privileges
CREATE SYNONYM
,并且在问题中遗漏了这一点? - Alex Poole