Create Read-Only User in Oracle

• Product: Aleph
• Product Version: 20, 21, 22, 23
• Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

Desired Outcome Goal:
Give an Oracle user read-only access in the whole database

Procedure:
To create a user which can only read the tables do (from a privileged user):
CREATE USER ronly identified by passw12;
grant create session to ronly;
grant select any table to ronly;

• Article last edited: 26-Jun-2016