Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Doubt in os level & oracle level authentication

Nirmalkumar
Frequent Advisor

Doubt in os level & oracle level authentication

Hi all,

Currently we are using os level privilige (sudo rights) to login in to the database.

EX:iam login to server A by means

login: username
password: passwd

% sudo su - ora9i
% password: paaswd
% sqlplus '/ as sysdba'
sql>

If i have planned to create a user(say EX: userA) in oracle and grant sysdba privilige to that user (userA).

What are the oracle activities i can & can't do at os level privilige and the oracle activities i can & can't do in oracle level privilige.


Help apperciated...

Thanks,
Nirmal.




1 REPLY
A. Clay Stephenson
Acclaimed Contributor

Re: Doubt in os level & oracle level authentication

Either zig or zag. Use sudo or su but not both. The answer is that either makes the effective UID equal to that of user ora9i. Whatever user ora9i can do, the sudo'ed or su'ed user can do. I assume that user ora9i is a member of the sysdba group; that allows the user to have special database priviliges.
If it ain't broke, I can fix that.