PPAS加策略、同义词、赋权、

-- 加策略

 select rds_add_policy(object_schema   => 'HRP_1001',

                      object_name     => 'HR_BASE_SALARY_TEMP',

                      policy_name     => 'POLICY_LIMITED_HRP',

                      function_schema => 'HRP_1001',

                      STATEMENT_TYPES => 'SELECT, INSERT, UPDATE, DELETE',

                      POLICY_FUNCTION => 'FN_LIMITED_HRP')

  from dual;

--加同义词

 create or replace  public synonym HR_BASE_SALARY_TEMP for HRP_1001.HR_BASE_SALARY_TEMP;

--修改ORG_ID   
ALTER TABLE HR_BASE_SALARY_TEMP ALTER ORG_ID  SET DEFAULT  
 to_number(substr((sys_context('USERENV'::character varying, 'SESSION_USER'::character varying))::text, (5)::numeric, (10)::numeric));

--赋权

GRANT INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER ON HR_BASE_SALARY_TEMP TO public;