Dear Experts ,
Suppose I want to set read only privilege on all tables.
For Example (just assume)
User X having various objects like (table , index, package , procedure, partition table , trigger, and functions , etc ..)
Now user y want to access all database objects of schema X.
Just read only privilege.
The problem is total objects counts are 5000+
>> User y needs read only privilege on all objects of Schema y
How do we set read only privilege ( to user y) on all objects of Schema X ?
DB Version is 12.2
Thanks in advance