SYSDBA and SYSOPER
Administrative privileges that are required for an administrator to perform basic database operations are granted through two special system privileges, SYSDBA and SYSOPER. You must have one of these privileges granted to you, depending upon the level of authorization you require.
The following are the operations that are authorized by the SYSDBA and SYSOPER system privileges:
System Privilege Operations Authorized SYSDBA Perform
- STARTUP and SHUTDOWN operations
- ALTER DATABASE: open, mount, back up, or change character set
- CREATE DATABASE
- CREATE SPFILE
- ARCHIVELOG and RECOVERY
- Includes the RESTRICTED SESSION privilege
SYSOPER Perform
- STARTUP and SHUTDOWN operations
- CREATE SPFILE
- ALTER DATABASE OPEN/MOUNT/BACKUP
- ARCHIVELOG and RECOVERY
- Includes the RESTRICTED SESSION privilege
The manor in which you are authorized to use these privileges depends upon the method of authentication that you choose to use.
When you connect with SYSDBA or SYSOPER privileges, you connect with a default schema, not with the schema that is generally associated with your username. For SYSDBA this schema is SYS; for SYSOPER the schema is PUBLIC.
2 comments:
fila disruptor
golden gooses
canada goose
nmd
balenciaga sneakers
golden goose
yeezy boost
westbrook shoes
nike air max 97
cheap nfl jerseys
j7z28e1f64 i0o47p8e67 l1b05y3z98 s5g86f0m91 n8l97r7e94 r9a40m2z76
Post a Comment