Grant Permissions to Role : Role « User Previliege « Oracle PL / SQL






  1. Oracle PL / SQL
  2. User Previliege
  3. Role

Grant Permissions to Role

   
SQL>
SQL> CREATE ROLE TestRole;
SQL>
SQL> GRANT UPDATE ON emp TO TestRole;
SQL>
SQL>
SQL> drop role Textrole;








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 CONNECT and RESOURCE Roles
5.Assign Role to User
6.Drop Role
7.Get two database users and show their roles.
8.Output session roles from procedure
9.Unassign Role