Versions Compared

Version Old Version 2 New Version Current
Changes made by

Aparna Rr

Aparna Rr

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 Below are the steps to Follow if the Unified Auditing is enabled on DB. If the Unified_Auditing is Enabled to log into Linux Syslog then you need to follow NXLog Community Edition. 

Read Only User CreationOracle 21c onwards

To Enable Read Only User

  • To start SQLPlus without logging in to a database, at a command prompt, type the following: sqlplus /nolog;

  • To connect as a system database administrator, at the SQLPlus prompt, type the following command: connect sys/password@SID as sysdba;

  • To create a read-only user, at the SQLPlus prompt, type the following commands:
    create user read_only_user identified by password;
    grant connect to read_only_user;

  • To grant select privileges for the database user, type the following commands:

...