PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

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>;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center