Grant with admin option : User Permission « User Privilege « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. User Permission
SQL>
SQL>
SQL> create user demo_ddl identified by demo_ddl;

User created.

SQL>
SQL> grant connect, resource to demo_ddl with admin option;

Grant succeeded.

SQL>
SQL> grant create user to demo_ddl;

Grant succeeded.

SQL> grant drop user to demo_ddl;

Grant succeeded.

SQL>
SQL> --@connect demo_ddl/demo_ddl
SQL>
SQL> drop user demo_ddl cascade;

User dropped.

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