Re: Insufficient Privileges with '/ as sysdba'

> This is true, however on Linux/UNIX it's a function of which O/S group
> has been delegated administrative rights to Oracle, and, as such,
> which O/S accounts are assigned that group. Buck is using his own O/S
> account, which is not assigned to the 'dba' group (or, whatever group
> he decided to assign admin rights to). That being the case the
> 'insufficient privileges' error rears its ugly head. All Buck need do
> is conncect to Linux as 'oracle' (presuming, again, that 'oracle' is
> the account which installed the software) and all should be well. The
> installer for UNIX/Linux asks which O/S group will be assigned admin
> rights within Oracle. Members of this group can connect to the
> instance as SYS as SYSDBA without a psssword locally. Actually,
> without a username, either:

I am in the dba and oinstall group, however my primary group is users.

I changed my primary group to be dba, but I still have the same problem.

"buck" is the user who installed Oracle.

So, I guess I'll have to poke around a bit more.

Thanks. Received on Tue Sep 21 2004 - 11:59:07 CDT