Database Administration (MOSC)

MOSC Banner

User with no insert privilege can insert via procedure

edited May 16, 2022 8:41PM in Database Administration (MOSC) 10 commentsAnswered ✓

This is on Oracle 19c

I have two users USERA and USERB, USERA creates an table TAB1 and grants only select privileges to USERB.

USERA creates an procedure TESTP which will insert the data into TAB1 and execute privilege is given to role ROLE1.

Now USERB is granted that role ROLE1.

But issue is USERB can execute that procedure TESTP and the data is also inserted into TAB1 by this user USERB, but when USERB tries to explicitly inserts the data into TAB1 table, it cannot.

Isn't that the permissions are checked when you are doing DML on the other schema objects via procedure?

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