dbTalk Databases Forums  

sys/password in Oracle

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss sys/password in Oracle in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
dparker@learnnc.org
 
Posts: n/a

Default sys/password in Oracle - 07-21-2003 , 08:09 AM






In Oracle 9i you can no longer log on as sys/password as you can with 8i.
Is there a way to make Oracle 9i behave like Oracle 8 in this regard?
Thanks in advance.

Reply With Quote
  #2  
Old   
TurkBear
 
Posts: n/a

Default Re: sys/password in Oracle - 07-21-2003 , 08:54 AM






dparker (AT) learnnc (DOT) org wrote:

Quote:
In Oracle 9i you can no longer log on as sys/password as you can with 8i.
Is there a way to make Oracle 9i behave like Oracle 8 in this regard?
Thanks in advance.

you can log in that way just by adding the 'as SYSDBA' clause to the login ..
Why would you want to reduce the new security ( actually, more of a reminder that you are connecting with a great deal of
power to mess things up) added by this requirement?





Reply With Quote
  #3  
Old   
TurkBear
 
Posts: n/a

Default Re: sys/password in Oracle - 07-21-2003 , 11:32 AM



dparker (AT) learnnc (DOT) org wrote:

Quote:
The reason I'm trying to log on as sys/password is that a 3rd party
software package's install process demands it. I could install 8i instead
but don't want to. Thanks.
Is that hard-coded into the app?, if so, contact the manufacturer and ask that it be updated to be 9i compatible, if not, use
the 'as SYSDBA' when logging in...



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.