My Oracle Support Banner

"Permission Denied" using SQL*Plus as Non-Oracle User (Doc ID 845313.1)

Last updated on FEBRUARY 03, 2022

Applies to:

SQL*Plus - Version to [Release Oracle10g to 11.1]
Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
IBM AIX on POWER Systems (64-bit)Symptoms

New installation of Database version 11.1 on AIX 5.3 Platform.

When attempting to run SQL*Plus with a non-oracle user, the following error occurs:

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Install Database software 11.1.
2. Run SQL*Plus as non-oracle user who does not belong to the dba unix group.
3. Error is returned.


This error does not happen with an oracle user or any user in the same unix group (dba) as oracle.

There is not any file for release 11.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.