DBA Data[Home] [Help]

APPS.EDW_SEC_POLICY dependencies on DBMS_RLS

Line 66: DBMS_RLS.ADD_POLICY(x_object_owner, fact_short_name, 'edw_sec_policy', 'apps', 'edw_sec_pkg.dim_sec', 'select', TRUE);

62: END IF;
63:
64: -- Associate the policy with fact table
65:
66: DBMS_RLS.ADD_POLICY(x_object_owner, fact_short_name, 'edw_sec_policy', 'apps', 'edw_sec_pkg.dim_sec', 'select', TRUE);
67:
68: EXCEPTION
69:
70: WHEN OTHERS THEN

Line 152: DBMS_RLS.DROP_POLICY(x_object_owner, fact_short_name, 'edw_sec_policy');

148:
149:
150: -- Remove the policy from fact table
151:
152: DBMS_RLS.DROP_POLICY(x_object_owner, fact_short_name, 'edw_sec_policy');
153:
154: EXCEPTION
155:
156: WHEN OTHERS THEN

Line 243: DBMS_RLS.ADD_POLICY(x_object_owner, fact_short_name, 'edw_sec_default_policy', 'apps', 'edw_sec_pkg.default_sec', 'select', TRUE);

239: END IF;
240:
241: -- Associate the policy with fact table
242:
243: DBMS_RLS.ADD_POLICY(x_object_owner, fact_short_name, 'edw_sec_default_policy', 'apps', 'edw_sec_pkg.default_sec', 'select', TRUE);
244:
245: EXCEPTION
246:
247: WHEN OTHERS THEN

Line 330: DBMS_RLS.DROP_POLICY(x_object_owner, fact_short_name, 'edw_sec_default_policy');

326:
327:
328: -- Remove the policy from fact table
329:
330: DBMS_RLS.DROP_POLICY(x_object_owner, fact_short_name, 'edw_sec_default_policy');
331:
332: EXCEPTION
333:
334: WHEN OTHERS THEN