Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

login confusion

ShrmaNov 25 2009 — edited Nov 25 2009

hi everbody, i have little confusion over oracle login

sql> conn sys as sysdba //OS authentication Am i right?
sql> conn sys as sysdba
password: ...... any differenece between these two?

now
sql> conn scott as sysdba //what is the purpose of this command as it shows user is "sys" i.e. scott will work on sys space? now i how i be able to restrict normal user to login like sysdba?

THNAKS all

Edited by: user12270655 on Nov 24, 2009 9:37 PM

This post has been answered by Maran Viswarayar on Nov 25 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 23 2009

Added on Nov 25 2009

#general-database-discussions

21 comments

789 views