Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

Grant CREATE SYNONYM, CREATE VIEW, CREATE DATABASE LINK, CREATE PUBLIC SYNONYM, DROP PUBLIC SYNONYM

SQL> SQL> GRANT CREATE SYNONYM, CREATE VIEW, CREATE DATABASE LINK,   2     CREATE PUBLIC SYNONYM, DROP PUBLIC SYNONYM TO RESOURCE; Grant succeeded. SQL>