Skip to Main Content
  • Questions

  • create an account equivalent to APPS but with read only access

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments, but we might still sneak in a few Office Hours sessions! Thanks for being a member of the AskTOM community.

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 10K+ times! This question is

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)

We're not taking comments currently, so please try again later if you want to add 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

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

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