我需要帮助了解用户需要何种授权/权限才能在指向另一个(不同的)模式对象时创建SYNONYM。创建同义词ora-01031权限不足
当我尝试下面的内容时,我得到的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
+0
您是否[授予'CREATE SYNONYM'给用户](http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_7001.htm#SQLRF54350)并错过了这个问题? –