Menu de navegação

[WendelParticipante]

Olá

Criei um usuario chamado WEN e este criou todas as tabelas, indices, views etc. Gostaria de saber o porque ele não consegue criar sinonimos publicos, já que no script abaixo ele tem permissão para isso a mensagem de erro é essa: ORA-01031: privilégios insuficientes

CREATE USER WEN
IDENTIFIED BY VALUES ‘E0A79C8251121A0F’
DEFAULT TABLESPACE WENTSD01
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
— 1 Role for WEN
GRANT CONNECT TO WEN WITH ADMIN OPTION;
ALTER USER WEN DEFAULT ROLE ALL;
— 29 System Privileges for WEN
GRANT DROP USER TO WEN WITH ADMIN OPTION;
GRANT CREATE ROLE TO WEN WITH ADMIN OPTION;
GRANT CREATE USER TO WEN WITH ADMIN OPTION;
GRANT CREATE VIEW TO WEN WITH ADMIN OPTION;
GRANT CREATE TABLE TO WEN WITH ADMIN OPTION;
GRANT DROP ANY ROLE TO WEN WITH ADMIN OPTION;
GRANT DROP ANY VIEW TO WEN WITH ADMIN OPTION;
GRANT CREATE SESSION TO WEN WITH ADMIN OPTION;
GRANT CREATE SYNONYM TO WEN WITH ADMIN OPTION;
GRANT CREATE TRIGGER TO WEN WITH ADMIN OPTION;
GRANT DROP ANY INDEX TO WEN WITH ADMIN OPTION;
GRANT DROP ANY TABLE TO WEN WITH ADMIN OPTION;
GRANT CREATE ANY VIEW TO WEN WITH ADMIN OPTION;
GRANT CREATE SEQUENCE TO WEN WITH ADMIN OPTION;
GRANT BACKUP ANY TABLE TO WEN WITH ADMIN OPTION;
GRANT CREATE ANY INDEX TO WEN WITH ADMIN OPTION;
GRANT CREATE ANY TABLE TO WEN WITH ADMIN OPTION;
GRANT CREATE PROCEDURE TO WEN WITH ADMIN OPTION;
GRANT DELETE ANY TABLE TO WEN WITH ADMIN OPTION;
GRANT DROP ANY SYNONYM TO WEN WITH ADMIN OPTION;
GRANT DROP ANY TRIGGER TO WEN WITH ADMIN OPTION;
GRANT CREATE TABLESPACE TO WEN WITH ADMIN OPTION;
GRANT DROP ANY SEQUENCE TO WEN WITH ADMIN OPTION;
GRANT CREATE ANY SYNONYM TO WEN WITH ADMIN OPTION;
GRANT CREATE ANY TRIGGER TO WEN WITH ADMIN OPTION;
GRANT DROP ANY PROCEDURE TO WEN WITH ADMIN OPTION;
GRANT CREATE ANY PROCEDURE TO WEN WITH ADMIN OPTION;
GRANT CREATE DATABASE LINK TO WEN WITH ADMIN OPTION;
GRANT EXECUTE ANY PROCEDURE TO WEN WITH ADMIN OPTION;
— 4 Tablespace Quotas for WEN
ALTER USER WEN QUOTA UNLIMITED ON USERS;
ALTER USER WEN QUOTA UNLIMITED ON GRATSL01;
ALTER USER WEN QUOTA UNLIMITED ON GRATSI01;
ALTER USER WEN QUOTA UNLIMITED ON GRATSD01;

[WendelParticipante]

O comando que utilizei para criar o sinonimo é:

CREATE PUBLIC SYNONYM NOMETABELA FOR WEN.AREA;

e da o erro: ORA-01031: privilégios insuficientes

[]’s Wendel

[gustavodesaParticipante]

Tente dar o previlégio abaixo e tente criar o sinonym novamente:

grant create any synonym to wen;

[Autor]

Posts