Database Security Products (MOSC)

MOSC Banner

How to grant SELECT ON not yet existing objects

edited Oct 3, 2012 6:03AM in Database Security Products (MOSC) 6 commentsAnswered
Hi,

I have been asked to grant read only access on applicative user (user1) to batch user (user2).

Schema of user1 consist of two types of tables - static tables (names of these tables don't change) and "temporary" tables are created and droped as part of Bussiness Proccess on daily basis.

For example every day I will have bunch of tables like TAB_reference_number and batach process (user2) will have to access to these tables.

I can grant explicitly select on static user1 tables but obviously I cannot do it for not yet existing tables.

I cannot (as far as know) use proxy user since it grants RW to the user1 schema.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center