oracle帮助文档——Oracle Database Security Guide

来源：互联网发布：免费视频聊天的软件编辑：程序博客网时间：2024/05/21 10:14

/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

阅读全文

0 0