oracle 授权同义词权限不足,创建同义词ora-01031权限不足

我需要帮助了解用户需要何种授权/权限才能在指向另一个(不同的)模式对象时创建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)并错过了这个问题？ –