oracle帮助文档——Oracle Database Security Guide

/5 Managing Security for Application Developers

5.4 Creating Secure Application Roles to Control Access to Applications

(1)

CREATE ROLE hr_admin IDENTIFIED USING sec_mgr.hr_admin_role_check;

(2)

GRANT SELECT, INSERT, UPDATE, DELETE ON HR.EMPLOYEES TO hr_admin;

(3)

CREATE OR REPLACE PROCEDURE hr_admin_role_check
 AUTHID CURRENT_USER 
 AS 
 BEGIN 
  IF (SYS_CONTEXT ('userenv','ip_address') 
    BETWEEN '192.0.2.10' and '192.0.2.20'
     AND
    TO_CHAR (SYSDATE, 'HH24') BETWEEN 8 AND 17)
  THEN
    EXECUTE IMMEDIATE 'SET ROLE hr_admin'; 
  END IF;
 END;
/

  
  

   
   来源： http://docs.oracle.com/cd/E11882_01/network.112/e36292/app_devs.htm#DBSEG147
  
  

/5 Managing Security for Application Developers

5.4 Creating Secure Application Roles to Control Access to Applications

(1)

CREATE ROLE hr_admin IDENTIFIED USING sec_mgr.hr_admin_role_check;

(2)

GRANT SELECT, INSERT, UPDATE, DELETE ON HR.EMPLOYEES TO hr_admin;

(3)

CREATE OR REPLACE PROCEDURE hr_admin_role_check
 AUTHID CURRENT_USER 
 AS 
 BEGIN 
  IF (SYS_CONTEXT ('userenv','ip_address') 
    BETWEEN '192.0.2.10' and '192.0.2.20'
     AND
    TO_CHAR (SYSDATE, 'HH24') BETWEEN 8 AND 17)
  THEN
    EXECUTE IMMEDIATE 'SET ROLE hr_admin'; 
  END IF;
 END;
/

   
   

    
    来源： http://docs.oracle.com/cd/E11882_01/network.112/e36292/app_devs.htm#DBSEG147