昨夜今晨:摩尔线程、沐曦股份IPO已获受理 安克新增充电宝召回方案
2025-07-01
SELECT * FROM employees; |
SELECT * FROM employees WHERE department_id = 60; |
CREATE OR REPLACE FUNCTION rls_dept (obj_owner IN VARCHAR2, obj_name IN VARCHAR2) RETURN VARCHAR2 AS predicate VARCHAR2 (200); BEGIN predicate := ''department_id = 60''; RETURN (predicate); END rls_dept; / |
BEGIN DBMS_RLS.ADD_POLICY(object_schema=>''HR'', object_name=>''EMPLOYEES'', policy_name=>''restrict_dept_policy'', function_schema=>''HR'', policy_function=>''rls_dept'', sec_relevant_cols=>''salary,commission_pct'', sec_relevant_cols_opt=>dbms_rls.ALL_ROWS); END; / |
评论 {{userinfo.comments}}
{{child.content}}
{{question.question}}
提交