Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> AW: Granting sysdba to a user

AW: Granting sysdba to a user

From: Libal, Ivo <ivo.libal_at_knapp-systems.com>
Date: Tue, 27 Jun 2000 10:42:39 +0200
Message-Id: <10541.110509@fatcity.com>


You must have=20
remote_login_password_file=3Dexclusive (not shared) and only 1 DB per password file (exclusive) Ivo Libal

> -----Urspr=FCngliche Nachricht-----
> Von: raman.yagna_at_db.com [SMTP:raman.yagna_at_db.com]
> Gesendet am: Dienstag, 27. Juni 2000 09:34
> An: Multiple recipients of list ORACLE-L
> Betreff: Granting sysdba to a user

>=20

> Hi all,
> Sorry for the previous mail. Clicked the wrong icon (send) .
>=20

> 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 ,
>=20

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

> I connect as ,
>=20

> sqlplus /nologs
> connect / as sysdba
>=20

> regards,
> Raman
>=20
>=20

> ---------------------- Forwarded by Raman Yagna on 27/06/2000 14:24
> ---------------------------
>=20 >=20

> To: ORACLE-L_at_fatcity.com
> cc:
>=20

> Hi all,
> I'm new to DBA related jobs. My boss wants to grant sysdba to =
a

> user .
>=20

> regards,
> Raman
>=20
>=20
>=20
>=20

> --=20
> Author:=20
> INET: raman.yagna_at_db.com
>=20

> 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 - 03:42:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US