Re: Q:DBA group in UNIX ...

From: L120bj <l120bj_at_aol.com>
Date: 1997/02/23
Message-ID: <19970223121401.HAA11637@ladder02.news.aol.com>#1/1

Is DBA the primary group for user1 and user2, ie if you type id at the command prompt do you see dba as the group. If so this may be the problem, as with some flavours of unix a user is not automatically allocated the groups he is assigned at logon time. So when you login as root your group is not dba. If you issue newgrp dba and then go in to ServerManager you should be okay. Hope this helps.

---

---

Subject: Re: Q:DBA group in UNIX ...
From: "Michael S. Abbey" <masint_at_shell.istar.ca> Date: 8 Feb 1997 21:21:10 GMT
Message-ID: <5diqo6$jre_at_news.istar.ca>

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 ?

I recall something about ROOT membership in the dba group. I believe group related access by root to secure database operations is restricted and not as easy deliberately as other memebrs of the dba group.

Michael

| Michael Abbey  masint_at_istar.ca
| Ottawa Canada (+1)613-290-5848 
| Co-author of         Oracle: A Beginner's Guide
|                      Tuning Oracle  
|                      Oracle Data Warehousing
 

Received on Sun Feb 23 1997 - 00:00:00 CST