RE: Granting sysdba to a user

From: <mleith_at_bradmark.co.uk>
Date: Tue, 27 Jun 2000 15:21:42 +0100
Message-Id: <10541.110538@fatcity.com>

Raman

I feel it necessary to warn you of the consequences that could bite you in=20= the *** as a result of granting this role=2E=20=

Granting SYSDBA to a user allows the user *ALL* system privileges with ADMIN=20=
OPTION, SYSOPER privileges (STARTUP, SHUTDOWN, ALTER DATABASE OPEN/MOUNT,=20=
ALTER DATABASE BACKUP, ARCHIVE LOG, and RECOVER, and includes the RESTRICTED=20=

SESSION privelege)=2E As well as permitting CREATE DATABASE and time-based=20= recovery=2E

Make sure that the user you are granting this role to has the proper=20= knowledge to use this role with the greatest of care=2E If it were me, I have=20= to say that I would not grant this to any user other than a Senior DBA=2E=20=

Just my 2 pence=2E

Cheers

Mark

-----Original Message-----

From:	MIME :dgoulet_at_vicr=2Ecom=20=
Sent:	27 June 2000 15:08
To:	ORACLE-L_at_fatcity=2Ecom
Subject:	Re:Granting sysdba to a user

Looks like you need to rebuild your password file=2E The command to do that=20= is:

orapwd file=3D<$ORACLE_HOME>/dbs/orapw<$SID> password=3D<whatever_you_like> entries=3D<x>

Where <x> is the number of users you'd like to have with either sysdba or sysadmin priviledges=2E I believe <x> defaults to 0 is not specified which=20= means
you can't grant this priviledge to anyone=2E

PS: I believe you'll have to re-grant sysdba and sysadmin to all users who currently have it=2E

Dick Goulet

____________________Reply Separator____________________
Author: raman=2Eyagna_at_db=2Ecom
Date:       6/26/00 11:34 PM

Hi all,
      Sorry for the previous mail=2E Clicked the wrong icon (send) =2E

My environment is
ORacle 8=2E1=2E6 =2E
Aix 4=2E3=2E2

What should i do to grant SYSBDA to user created =2E Now its failing with the following error ,

ORA-01994: GRANT failed: cannot add users to public password file

I connect as ,

sqlplus /nologs
connect / as sysdba

regards,
Raman

Forwarded by Raman Yagna on 27/06/2000 14:24

To: ORACLE-L_at_fatcity=2Ecom
cc:

Hi all,

I'm new to DBA related jobs=2E My boss wants to grant sysdba to a user =2E

regards,
Raman

Author: INET: raman=2Eyagna_at_db=2Ecom

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity=2Ecom (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from)=2E You may
also send the HELP command for other information (like subscribing)=2E -- Author: INET: dgoulet_at_vicr=2Ecom

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------