User with no insert privilege can insert via procedure
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?