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

Breadcrumb

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

https://connor-mcdonald.com/2020/08/25/schema-level-grant-in-oracle/

That could be easily tailored to your needs

Rating

  (1 rating)

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

Comments

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

Hi,

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