How to create a user with read-only/view privileges on all schema objects?

Question

Oracle

Hello!

Can you tell me how to create a user with "read-only/view" privileges for all objects of a particular schema in an Oracle database? By objects I mean: SEQUENCE, PROCEDURE, PACKAGE, PACKAGE BODY, TYPE BODY, TRIGGER, TABLE, INDEX, FUNCTION, VIEW, JOB, TYPE.

Purpose: to create users for technical support, so that they would have access to view all objects of a particular schema without the need to cut access for new schema objects.

Previously, one of the familiar DBAs used the following approach:
1) A proxy user was created that had access to connect to a specific scheme
2) After some way he cut access, so that the connected proxy user would have access only to view all objects of the scheme, but could not change anything (by default, all access rights of the scheme are inherited).

I did not find how it is implemented in any of the publicly available sources on the Internet.

Maybe among experienced DBAs there is experience in similar configurations of access rights to the Oracle database schema and they will suggest solutions.

Answer 1

I did not find how it is implemented in any of the publicly available sources on the Internet.

Are you sure you were looking? ( oracle read only user for schema )