Database Administration (MOSC)

MOSC Banner

APPS grants and best practices

edited Feb 18, 2020 1:46AM in Database Administration (MOSC) 4 commentsAnswered

Hello, where can I find documentation about APPS user best practices on EBS?

i.e. Should/must APPS user have all privileges on all GL, AR, AP,  . . .  objects with grant option?

Something like "GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES, INDEX, ALTER, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON AP.AP_SUPPLIER_SITES_ALL TO APPS WITH GRANT OPTION;"

i.e. Who should/must have APPS password? Development group, administration group, . . . .?

Thank you so much.

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