Sys user as sysdba

[Pradeep bhatt]

Normal users log as

scott/tiger

But sys logs as

sys/xxx as sysdba

I understand that Sys is a user ,right? What is sysdba ? Is it a privilege?

I can also log as sys/xxx as sysoper ?

Is the password same for sysoper and sysdba? Or they both sys(logging with sysdba ) and sys (logging as sysoper) the same user?

[Nicholas Cheung]

I understand that Sys is a user ,right?

YES.

What is sysdba ? Is it a privilege?

It is a role with DBA privilege.

I can also log as sys/xxx as sysoper ?

YES, but the access right is different. If I am correct, SYSDBA can do anything, but SYSOPER cannot perform startup and shutdown.

Is the password same for sysoper and sysdba? Or they both sys(logging with sysdba ) and sys (logging as sysoper) the same user?

NOPE. They are just 2 roles. Depending on the user, they might have different password.

Nick

[Pradeep bhatt]

NOPE. They are just 2 roles. Depending on the user, they might have different password

Does this mean that a single user "sys" has 2 passwords depending on privilege used to login?

[Nicholas Cheung]

Nope, "sys" only has 1 password, however, if he has multiple roles, he can login as he wants, by using "as sysdba", "as sysoper" or other valid roles.

Nick

[Jeanne Boyarsky]

Pradeep,
This article expands on what Nicholas has said.

[Pradeep bhatt]

Thanks Jeanne

[guo dong]

sqlplus / nolog
>connect /as sysdba

[Nicholas Cheung]

Thanks Jeanne.

sqlplus / nolog
>connect /as sysdba

This is just for login with verification by OS, and seems not really related to the discussion.

Nick