Re: Q:DBA group in UNIX ...

Pere Juanola wrote:
>
> Hello,
> I have ORACLE 7.2 installed on Digital Unix and I'm trying to have 4
> more DBA users.
>
> I modified the /etc/group and added to DBA group the 4 users :
>
> DBA:*:111:oracle,user1,user2,root,user3
>
> user1, user2 : normal users of UNIX
> user3: user with UID 0 (as root)
>
> Then I tried to access to svrmgrl and connect internal, with 'user1'
> and 'user2' I had no problem but with 'root' I was asked to enter the
> password.
>
> Can somebody tell me what I'm doing wrong, or if a user with super-user
> privileges (UID 0) can't connect internal whitout password ?
>
>
> ===================================================================
> Pere Juanola i Juanola
> E-Mail : pjuanola_at_grn.es
> http://www.grn.es/personals/pjuanola
> ===================================================================

You might try adding root to the dba group in /etc/group.

I believe that Oracle is getting the uid of the user and looking it up in /etc/passwd. It uses that to get the username and checks the username against /etc/group. Since your uid is 0 and the first entry that has a uid of 0 in /etc/passwd is root and root is not in the dba group, you must enter a password.

But I could be wrong. Many UNIX apps work this way. Oracle probably does too.

-- 
Thomas Griffin
Project Leader
QUALITECH Systems, Inc.
tgriffin_at_qualitech.com