we have W2K platform so if i understand correctly i put my NT account in the ORA_DBA group, then connect / as sysdba and grant the rights.
> -----Oorspronkelijk bericht----- > Van: Peter Gram [SMTP:[EMAIL PROTECTED]] > Verzonden: woensdag 15 mei 2002 12:49 > Aan: Multiple recipients of list ORACLE-L > Onderwerp: Re: grant sysdba rights > > > The answer depends on what O/S you are on. > > Unix : > When the oracle software was installed you where asked about a Unix > group (normally called dba) that has privileges > this group is then compiled and linked into the Oracle executable. > When member of this group you can connect with "/ as sysdba" and > from there grant sysdba to the user > > NT : > Since it is not possible to relink the code on NT the group is hard > coded to "ORA_DBA" on NT/W2K > When member of this group you can connect with "/ as sysdba" and > from there grant sysdba to the user > > VMS : > Here it is a system logical that i don't remember the name off ( > Michael / Mogens pleas help ) > When having this logical set you can connect with "/ as sysdba" and > from there grant sysdba to the user > > MVS : > Help ??????? > > [EMAIL PROTECTED] wrote: > > >Hi list > > > >When the system account needs the SYSDBA role granted , i simply connect > as > >internal and grant that role to system. > >But the connect internal is obsolete in oracle 9i, so how do i grant the > >sysdba role to other accounts ?? > > > >thanks > > > > > >vr. gr. > >g.g. kor > >rdw ict groningen > > > > > > -- > > /regards > > Peter Gram > > Mobil : +45 2527 7107 > Fax : +45 4466 8856 > > Miracle A/S > Kratvej 2 > 2760 Måløv > http://miracleas.dk > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Peter Gram > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).