Re: Oracle V7 and User setup/rights...etc
Date: 1996/04/04
Message-ID: <316452CA.7BAA_at_ibm.net>#1/1
Wolfie a.k.a. Joe Greene wrote:
>
> I am a computer operations Specialist with a UNIX specialization. We
> have recently acquired Oracle v7 for our HP-UX box. Unfortunately I am
> in charge of cleanup and configuration of both of our HP-UX systems.
> However the Database administrator is a lazy snot. We got Oracle and he
> had to call in a specialist from Oracle (he never bothered to ask
> me...he's afraid I can do his job..which I don't want and probably
> couldn't do...or I would be a DB admin....) in to get it installed.
> After Installation he promptly absconded with ALL documentation... I
> waaxs then told to get it set up in the startup and shutdown procedures
> for the system. After aggressively poking around in Oracle's sqldba
> utility and some scripts (dbshut and dbstart) I figured out the proper
> procedure to do this...Cool..I got the environment variables
> set..great...oh bugger...the root account cannot do a connect
> internal..I get the error "Insufficient Priviliges".
>
> Ok..more aggressive poking and a few strategic questions later, I now
> know that the user oracle of group dba is set as the admin
> account..cool..I can get to there from the root account..
>
> Crumb..I poked in security, create a ROOT user (I typed root and oracle
> spit out ROOT), go back into Security and select 'grant privileges (esc
> g)' (or was that rights..I forget...there was only one grant option
> though)..cool..I pull up the list and grant the ROOT user all
> priviliges.
> I go back to the root account... no luck...What am I doing wrong?
> What should I be doing?
> I can't get the docs due to politics and the DBAdmin has nuked the
> online copies....blast it I need man pages!!!
>
> Please help. E-mail me with replies please.
> --
> LEGO: TC,MOC+++ #+>+++ S+++ LS+>++ Hri A>+ M>+ YB72m
> Need more LEGOs
> Joe Greene
> jngreene_at_nyx.cs.du.edu
> http://nyx10.cs.du.edu/~jngreeneJoe,
In order for you to connect internal, you need to be member
of the OS group "dba" . You are in charge of your Unix system, so
practically you can make anybody able to connect internal & do
what he/she pleases with the Oracle instance!!!!
On not technical note, I would recommend that instead of playing politics
with your "Oracle DBA", maybe you should try working together with the
best interest of all involved in mind ( including your employer ).
Good luck, you will need it..
Halina Monka
DBA-Toysrus Canada
Received on Thu Apr 04 1996 - 00:00:00 CEST