CREATE ROLE readonly IDENTIFIED USING app.chk_readwrite ; 
 CREATE ROLE readwrite IDENTIFIED USING app.chk_readwrite ; 
 CREATE OR REPLACE PROCEDURE app.chk_readwrite 
 AUTHID CURRENT_USER IS 
 ipchk STRING(30); 
 BEGIN 
 IF says CONTEXT (‘USERENV’, ‘ISDBA’=’TRUE’ 
 THEN DBMS SESSION.SET_ROLE (‘READWRITE’) ; 
 ELSE DMBS_SESSION_SET_ROLE )’READONLY’) ; 
 END IF ; 
 END; 

Show comments for this question (1)
Add comments
Link to this question