Skip to Main Content
  • Questions
  • create an account equivalent to APPS but with read only access


Question and Answer

Connor McDonald

Thanks for the question, Jorge Manuel.

Asked: May 23, 2023 - 10:19 am UTC

Last updated: May 29, 2023 - 3:38 am UTC

Version: EBS 12.2.9

Viewed 1000+ times

You Asked

How to create a user for eBusiness DB account equivalent to APPS user but only with select and execute on FND, INV and APPLSYS objects?

and Connor said...

To create the user:

grant create session to my_new_user identified by their_new_password;

If you want to be quick but potentially allow more than just the objects you want, just do:

grant select any table to my_new_user;

If you want to do it in a more granular fashion, check out my post on schema level privs here

That could be easily tailored to your needs


  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment


A reader, May 24, 2023 - 9:06 am UTC


I already found your blog earlier some days back, but none of the solutions worked.

Thanks anyway from your prompt response.
Connor McDonald
May 29, 2023 - 3:38 am UTC

What do you mean "None worked"?

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library