Shulou(Shulou.com)06/01 Report--

1the default username and password of oracle

User name / password login identity (role) description

Sys/change_on_install SYSDBA and SYSOPER cannot log in as NORMAL

System/manager NORMAL cannot log in as SYSDBA or SYSOPER

Scott/tiger NORMAL ordinary user

2, user sys and system

Sys: sysdba (system administrator) sysoper (system operator) dba (database administrator role)

System: dba (Database Administrator role) sysoper (system operator)

3. Sysdba and sysoper

Sysdba

Sysoper

Startup (start the database)

Startupshutdown (shut down the database)

Shutdownalter database open/mount/backup

Alter database open/mount/backup changes the character set

Can't.

Create database (create database)

Cannot drop database (delete database)

Can't.

Create spfile

Create spfilealter database archivelog (archive log)

Alter database archivelog has restricted session (session restriction) permission

Have restricted session (session restriction) permission

Allows users to connect as sys users

Some basic operations can be performed, but user data cannot be viewed.

After landing, there is sys.

After landing, there is public.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.