CREATE USER userName IDENTIFIED BY password and grant permission : User Permission « User Privilege « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. User Permission
SQL> CREATE USER user1 IDENTIFIED BY pass1;

User created.

SQL> CREATE USER user2 IDENTIFIED BY pass2;

User created.

SQL> GRANT CREATE SESSION TO user1, user2;

Grant succeeded.

SQL>
SQL> DROP USER user1;

User dropped.

SQL> DROP USER user2;

User dropped.








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