Assign CONNECT and RESOURCE Roles : Role « User Previliege « Oracle PL / SQL






Assign CONNECT and RESOURCE Roles

   
SQL>
SQL> CREATE USER Alice IDENTIFIED BY simplepassword;

User created.

SQL>
SQL> GRANT CONNECT, RESOURCE to Alice;

Grant succeeded.

SQL>
SQL>
SQL> drop user alice;

User dropped.

SQL>
SQL>

   
    
    
  








Related examples in the same category

1.Creating a Role
2.define a role as a global role, which means that a user can only be authorized to use the role by an enterprise directory service.
3.use a password when a role is authorized by the database
4.Assign Role to User
5.Drop Role
6.Get two database users and show their roles.
7.Output session roles from procedure
8.Grant Permissions to Role
9.Unassign Role