Oracle Database Discussions

Hi All,

I am unable to give read only access to newly created user in the Oracle database. I granting read only permission to the user, but problem is that this user is able to delete the data from any table or schema.

We need to give only 'Read Only' access to user which will do sql query to any table,schema etc.


I have followed following steps.

1. Created user

2. Granted following privilege

CREATE SESSION

SELECT_ANY_TABLE;

SELECT_ANY_DICTIONARY

Please guide on the same.