OraFAQ Forum: Security » sys system sysdba sysoper

Home » RDBMS Server » Security » sys system sysdba sysoper

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sys system sysdba sysoper [message #57036]

Thu, 15 May 2003 18:35

Chris
Messages: 128
Registered: November 1998

Senior Member

I'm learning oracle and am very puzzled/confused with these -- sys system sysdba sysoper.

While I understand only sys and system are user accounts (not sysdba or sysoper), I don't understand why when you log in as sys, you have to choose "as sysdba" or "as sysoper".

When you login as a user, in the case as sys, that user has the roles/privileges that go with it. Like login as root on a unix machine, you have super user privilege. Or as administrator on NT box, you are super user (roles and privileges already assigned)

Could you shred some light on this?

Chris

Report message to a moderator

[Message index]

		sys system sysdba sysoper By: Chris on Thu, 15 May 2003 18:35
		Re: sys system sysdba sysoper By: Sanjay on Mon, 19 May 2003 09:24
		Re: sys system sysdba sysoper By: Chris on Tue, 20 May 2003 12:47
		Re: sys system sysdba sysoper By: vishal0soni on Fri, 14 January 2011 03:54
		Re: sys system sysdba sysoper By: Michel Cadot on Fri, 14 January 2011 04:11
		Re: sys system sysdba sysoper By: Roachcoach on Fri, 14 January 2011 05:03
		Re: sys system sysdba sysoper By: cookiemonster on Fri, 14 January 2011 07:58

Previous Topic:	Audit Vault How to
Next Topic:	Viewing Trigger Code

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 01:54:17 CDT 2024