Grant CREATE SYNONYM, CREATE VIEW, CREATE DATABASE LINK, CREATE PUBLIC SYNONYM, DROP PUBLIC SYNONYM : User Permission « User Privilege « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. User Permission
SQL>
SQL>
SQL> GRANT CREATE SYNONYM, CREATE VIEW, CREATE DATABASE LINK,
  2     CREATE PUBLIC SYNONYM, DROP PUBLIC SYNONYM TO RESOURCE;

Grant succeeded.

SQL>
SQL>








36.2.User Permission
36.2.1.To connect to the database a user must be granted the permission to create a session, which is the CREATE SESSION system privilege.
36.2.2.CREATE USER userName IDENTIFIED BY password and grant permission
36.2.3.Create user and grant permission
36.2.4.Grant all possible permissions
36.2.5.REVOKE CREATE TABLE, CREATE CLUSTER, CREATE SYNONYM, CREATE VIEW, CREATE SEQUENCE, CREATE DATABASE LINK FROM CONNECT
36.2.6.Grant CREATE SYNONYM, CREATE VIEW, CREATE DATABASE LINK, CREATE PUBLIC SYNONYM, DROP PUBLIC SYNONYM
36.2.7.Grant connect and resource permission to a user
36.2.8.Grant connect permission to a user
36.2.9.Grant with admin option
36.2.10.Grant connect to permission to all name in a table
36.2.11.grant select on tableName to userName
36.2.12.grant administer database trigger to userName
36.2.13.grant execute on dbms_rls to userName
36.2.14.grant create any context to userName
36.2.15.Revoke Permissions
36.2.16.Revoke Permissions with Cascade
36.2.17.Get user name from all_users