1752806 Members
6705 Online
108789 Solutions
New Discussion юеВ

oracle user & group

 
Nonie_2008
Advisor

oracle user & group

Hi..

currently i create oracle user id using SAM and grant with dba role (dba group never exist before)

can someone guide me if any other things i should do for this 'oracle' user?

one more thing, i try to run bdf command when login as oracle. but error comes out like this:

bdf: unable to lock /etc/mnttab after 100 tries
bdf: /etc/mnttab : permission denied.

anyone got idea?

Thanks

-Mahani-
6 REPLIES 6
saju_2
Respected Contributor

Re: oracle user & group

Hi

What is the file permission for bdf

bash-2.05# ls -lrt /usr/bin/bdf
-r-sr-xr-x 1 root bin 24576 Jan 10 2001 /usr/bin/bdf

Whether ur bdf file also has the same permission..?
Nonie_2008
Advisor

Re: oracle user & group

Hi Saju,

i try ll in /usr/bin it gives result as follows:

-rwxrwxrwx 1 root bin 56932 May 19 2005 bdf

Thanks
saju_2
Respected Contributor

Re: oracle user & group

Hi

Can you try changing the file permission to 4555 (SETUID)

chmod 4555 /usr/bin/bdf
and try bdf again

Nonie_2008
Advisor

Re: oracle user & group

Hi Saju,

ok.. i can bdf now using oracle ID. thanks a lot!

best regards,
Mahani
saju_2
Respected Contributor

Re: oracle user & group

Hi

If u set UID to a executable, that command will executed with root permission, and it wont consider the actual user who is executing that command. Some commands like passwd require this permission and without this SUID, all users cannot execute those commands.

Hope this explains ur query and feel free to assign points...:)

Warm regards
Saju
Nonie_2008
Advisor

Re: oracle user & group

Thanks Saju.. i am more clear about that now.

Thanks for your help.

Points forwarded ! :)