Grant Permissions : Grant Permission « User Previliege « Oracle PL / SQL






Grant Permissions

    
SQL>
SQL> CREATE USER Alice IDENTIFIED BY simplepassword;

User created.

SQL>
SQL> GRANT SELECT, INSERT ON emp TO Alice WITH GRANT OPTION;

SQL>
SQL> drop user alice;

User dropped.

SQL>
SQL>
SQL>
SQL>

   
    
    
    
  








Related examples in the same category

1.Create a user and grant the permission
2.grant all on directory DirName to User
3.Grant permission to system
4.Grant update permission
5.Column-Level Object Privileges
6.add the additional ALL clause to a GRANT statement in order to grant all possible privileges
7.Procedure, function, and package privileges: EXECUTE and DEBUG
8.Materialized view privileges: SELECT and QUERY REWRITE
9.Directory privileges: READ and WRITE
10.grant one type or all types of privileges at once on any given object.