Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to allow sqlplus sqlldr usage by a local non osoper non osdba member

sldOct 2 2025

Hi All,
Im on oracle server 9.2 already installed and working on solaris .

I've oinstall ( owner inventory group ) and osdba ( sysdba enabled group )
existing ora-92:osdba os user is used to fully manage the server .

Now I need to create new local os user (ora-simply-user ) intended to work with the local instance without sysdba / sysoper privileges .

the Os user ora-simply-user should be able to run
sqlplus username/passwd
sqlldr username/passwd

Which group the new ora-simply-user should be member of ?

Tx in advance
Stefano

Comments
Post Details
Added on Oct 2 2025
0 comments
26 views