Grant execute to ps_accessid> - Who is ps_accessid and if I have to grant this execute privilege
edited Sep 21, 2012 3:34AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered ✓
Hi experts.
Per document named PT850_852_RequiredPatchesOracle_PSFT.xls, I need to know if this execute grants need to granted and to whom (specific name).
As of May 2010, Oracle recommends that customers not set O7_DICTIONARY_ACCESSIBILITY=TRUE since this parameter may compromise database security. The recommended solution is to set O7_DICTIONARY_ACCESSIBILITY=FALSE in your init.ora parameter list and run the following two sql statements using sysdba privilege (user sys):
SQL> GRANT SELECT_CATALOG_ROLE to <PS_ACCESSID>;
SQL> GRANT EXECUTE_CATALOG_ROLE to <PS_ACCESSID>;
Per document named PT850_852_RequiredPatchesOracle_PSFT.xls, I need to know if this execute grants need to granted and to whom (specific name).
As of May 2010, Oracle recommends that customers not set O7_DICTIONARY_ACCESSIBILITY=TRUE since this parameter may compromise database security. The recommended solution is to set O7_DICTIONARY_ACCESSIBILITY=FALSE in your init.ora parameter list and run the following two sql statements using sysdba privilege (user sys):
SQL> GRANT SELECT_CATALOG_ROLE to <PS_ACCESSID>;
SQL> GRANT EXECUTE_CATALOG_ROLE to <PS_ACCESSID>;
0