use a password when a role is authorized by the database : Role « User Previliege « Oracle PL / SQL






use a password when a role is authorized by the database

  

CREATE ROLE clerk IDENTIFIED BY password;

drop row clerk;


   
  








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.Assign CONNECT and RESOURCE Roles
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