Is it possible for an Oracle user without access to a tablespace to insert values into a table placed in this tablespace?

Asked Dec 21 '18 at 11:45

Active Dec 21 '18 at 16:08

Viewed 28 times

I revoked a user's access to a tablespace.

I thought that this user wouldn't acomplish to insert data in tables from this tablespace. But this user still can.

Is this the normal behaviour or am I missing something?

Thank you

edited Dec 21 '18 at 16:08

asked Dec 21 '18 at 11:45

frankdart

So, I found this. This user has no access to the table space but he has a role assigned to him that let's him insert data in this table. Is this normal? – frankdart Dec 21 '18 at 12:22
Yes, it is "normal." – OldProgrammer Dec 21 '18 at 18:30

0 Answers0