79653

About Administration Privileges for Startup and Shutdown

To start or shut down thc Oracle instancc, you must conncct to thc instancc with a special connection privilege. There are two of thesc privileges: SYS DBA for fully empowered database administrators and SYSOPER for users who start and shut down thc database, but have no privilcgcs to acccss uscr objeets.

When you crcate an Oracle database, there are two primary administrative uscr accounts that are automatically created: SYS and SYSTEM. Both of thesc users have fuli

database administration privileges, but initially, only user SYS or SYSTEM can

connect

Sec Also:

■"About Instance Memory Structures" on page 5-4

mOracle Database Concepts for morę information about the SGA

Sec Also:

■"About Server and Client Processes" on page 5-4 for morę information about dedicated server and shared server modes mOracle Database Concepts for morę information about the PGA See Also:

■"Shutting Down and Starting Up thc Oracle Instancc" on page 5-8

mOracle Database Concepts

Overview of the Oracle Instance and Instance Management

Managing the Oracle Instance 5-7

with the SYSOPER privilege. Therefore, until you grant the SYSOPER privilege to other

users, you must connect to the Oracle instance as user SYS or SYSTEM to start and shut

down thc instancc. When connccting (logging in) as user SYS, you must always specify

that you are connect i ng AS SYSDBA.

Wyszukiwarka

Podobne podstrony:
About Instance Startup Whcn you start thc Oracle instance, you typically start it such that the Stat
ms 020 For Strength and Muscle to Plan Arrow points to your CORRECl wcight 0.LV 11- you »tand still
15078 smpb 21 Disease and wcakness is thc way to death naturę for men and boys to cravc strength and
About Instance Shutdown Instance shutdown is thc reverse of instance startup. When you shut down the
ANPR cameras captures images for evidence and LPN. registers his or her intent to use road
About Memory Management Memory managcmcnt involves maintaining optimal sizes for thc Oracle instancc
p Schedule Schedule for courses and activities Choose one or morę courses and groups Courses (term
and verify that the Mini Setup Wizard is operating correctly. You must run Sysprep.exe again to rese
555 timer circuit for maker?ire music player to batteries or AC to DC wali adaptor R2 555 timer
Shutting Down and Starting Up Using SQL*Plus You can shut down and start thc Oracle instance using S
About User Accounts For users to access your database, you must crcatc user accounts and grant appro
About User Privileges and Roles User privileges provide a basie level of database security. Thcy arc
SYSDBA and SYSOPER System Privileges SYSDBA and SYSOPER are administrativc privileges required to pc
Homer ochrony osobiste USETHERIGHT PPE FOR THE JOB. DO YOU KNOW WHEN AND WHERE TO WEAR PPE?

więcej podobnych podstron