Re: ?Only DB owner can run sqlplus?
Date: 1996/07/02
Message-ID: <4rc6kg$bdb_at_nntp.ucs.ubc.ca>#1/1
Bob Stewart (bob_at_latcost1.alaao.ats.eds.com) wrote:
: I'm having a problem with a seldom used instance we host for another
: group in our company. For some reason, only the Oracle user can run
: sqlplus. When another user tries to run sqlplus, I get the following
: messages:
I'm not going to be *too* helpful since I don't know much about Oracle, but I can answer your question in the subject header and that is, no. You're right...everyone should be able to run sqlplus, but to actually access the database, the restriction is placed by the DBA with the grant command.
I can't really understand what is your problem. If it was a unix system, I would think that maybe the group or other permission was turned off on the executable...but that can't be it, since it did run...just not properly.
I'm not sure if instances have permissions attached to them...so maybe you can look into that. Sorry I can't be more help to you.
Raymond Wan
- ------------------------------------------------ **
- Raymond Wan **
- Department of Computer Science, **
- University of British Columbia **
- e-mail: rkwan_at_unixg.ubc.ca **
- WWW: http://www.ugrad.cs.ubc.ca/spider/h0h1 **
- ------------------------------------------------ **