Mega Code Archive

 

Categories / Oracle PLSQL / User Previliege

 

Define a role as a global role, which means that a user can only be authorized to use the role by an enterprise directory

CREATE ROLE supervisor IDENTIFIED GLOBALLY; drop role supervisor; --