--模拟MOAC登陆之前初始化
BEGIN
fnd_global.apps_initialize(user_id => 2393,
resp_id => 50691,
resp_appl_id => 201);
mo_global.init(p_appl_short_name => 'PO'); -- 在11i的版本中不用执行mo_global.init,R12新增
END;
--VPD技术,DBA_POLICIES这张表中存储了启用VPD技术的表
SELECT * FROM DBA_POLICIES WHERE object_name = upper('pa_projects');
--给某张表启用VPD
--1.Create Data
create table t (x number);
insert into t values (1);
insert into t values (2);
insert into t values (10001);
insert into t values (10002);
commit;
select * from t;
output:
1
2
10001
10002
--2.Create VPD FUNCTION