EBS Customizations (MOSC)

MOSC Banner

read only user

edited Jan 8, 2019 5:05PM in EBS Customizations (MOSC) 2 commentsAnswered

when creating a read only user, is it better to grant the select grant to a user or to create a role and grant the grants to the role then give this role to the read only user.

In the case of EBS.  Should you grant select on the ebs-schema.table such as ar.table or po.table or to apps.table?

My dba granted select to the tables ebs-schema.table.  This was ok, then the user complained because they use apps.tablename and so he granted apps.table to the read-only role.

When he did this, 5000 objects became invalid and everything stopped.  What would cause this behavior?

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