Create a user and grant the permission : Grant Permission « User Previliege « Oracle PL / SQL






Create a user and grant the permission

 
create user java2s identified by password;

grant create session, dba to java2s;

connect java2s/password;

--DROP USER java2s;


           
         
  








Related examples in the same category

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