Re:Granting sysdba to a user

From: <dgoulet_at_vicr.com>
Date: Tue, 27 Jun 2000 09:20:41 -0400
Message-Id: <10541.110527@fatcity.com>

Looks like you need to rebuild your password file. The command to do that is:

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

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

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

Dick Goulet

____________________Reply Separator____________________

Subject: Granting sysdba to a user
Author: raman.yagna_at_db.com
Date: 6/26/00 11:34 PM

Hi all,

Sorry for the previous mail. Clicked the wrong icon (send) .

My environment is
ORacle 8.1.6 .
Aix 4.3.2

What should i do to grant SYSBDA to user created . 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.com
cc:

Hi all,

I'm new to DBA related jobs. My boss wants to grant sysdba to a user .

regards,
Raman

-- 
Author: 
  INET: raman.yagna_at_db.com

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.com (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).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jun 27 2000 - 08:20:41 CDT