Re: system privileged functions

In <1906_at_pivot-sts.sbi.com> crow_at_seyton.sbil.co.uk (Jason Crow) writes:

>In article 17098_at_statoil.no, oracle_at_ddb.be.statoil.no (Oracle ) writes:
>>Hi.
>>Why does sqldba responds 'ORA-01031: insufficient privileges'
>>when the root user is trying to do sqldba shutdown or connect internal,
>>even if the root is a proper member of group dba?
>> (/etc/group:
>> dba:*:101:root,oracle,dba1,dba2)
>>It works fine for the users oracle, dba1 and dba2.
>>It also works fine for additional users added to the group dba.
>>
>>(By the way, I'm running Oracle 6.0.36.5.1 on a Sun SPARC 10)
>>
>>Torstein

>I had the same problem running 6.0.36 on a Sparc10. It seems that unless your default group is dba, you need to run "newgrp dba" before running sqldba etc..
 

>Alternativly from root, you can "su - oracle -c dbshut"

This is standard (and correct) System V behaviour. Looks like Sun is finally providing *real* System V compatibility.

graeme

--
Disclaimer:	The author's opinions are his own, and not necessarily
		those of Pyramid Technology Ltd. or Pyramid Technology Inc.
---------------------------------------------------------------------------
      -m------- Graeme Sargent                 Voice: +44 (0)252 373035
    ---mmm----- Senior Database Consultant     Fax  : +44 (0)252 373135
  -----mmmmm--- Pyramid Technology Ltd.        Telex: Tell who???
-------mmmmmmm- Farnborough, Hants  GU14 7PL   Email: graeme_at_pyra.co.uk
---------------------------------------------------------------------------
    We have the technology.  The tricky bit is learning how to use it.