sys difference with the system

2010-04-05  来源:本站原创  分类:Database  人气:172 

1) The most important difference, the importance of data stored in different sys】 【all oracle data dictionary base tables and views are stored in the sys user, these base tables and views for the oracle operation is essential, by the maintenance of the database itself, any user can manually change. sys user has dba, sysdba, sysoper other role or authority, is the highest authority of the user oracle.

【】 User system for internal data storage sub-level, such as the oracle of some features or tools of management information. system users have the role of general dba privileges.

2) Second, the difference between the different permissions.
【】 Users can only use the normal system as landing em, unless you give it a sysdba of system privileges or syspoer system privileges.
Sys】 【user has "SYSDBA" or "SYSOPER" system permissions, landing em can only use these two identities, which can not normal.
To sys user login Oracle, the implementation of select * from V_ $ PWFILE_USERS; can be found to have a sysdba privileged user, such as:
SQL> select * from V_ $ PWFILE_USERS;
USERNAME SYSDBA SYSOPER
SYS TRUE TRUE
Sysdba and sysoper difference between the two system privileges

normal, sysdba, sysoper What is the difference
normal is a normal user the other two, you have their permission to examine the known
sysdba has the highest system privileges, after landing a sys
sysoper mainly used to start, shut down the database, sysoper after the user is a public landing

sysdba and sysoper are system privilege, also known as administrative privilege, have such a database open and close like a number of administrative level permissions sysdba and sysoper specific permission may have a look below:

sys difference with the system

system if the normal login, it is actually a common dba user, but if as sysdba login, the result in fact it is the user logged on as sys This is similar to Linux's sudo feeling inside, from the login information which we can see out. Therefore, after connecting to the database as sysdba, create the objects are actually generated in the sys. The same is true of other users, if as sysdba login as sys user is logged on to see the following experiment:
SQL> create user strong identified by strong;
The user has been created.
SQL> conn [email = strong / strong @ magick] strong / strong @ magick [/ email] as sysdba;
Connected.
SQL> show user;
USER is "SYS"
SQL> create table test (a int);
Table has been created.
SQL> select owner from dba_tables where table_name = 'test';
Not the selected row / / create the table because oracle automatically converted to uppercase, so use lower case when the investigation does not exist;
SQL> select owner from dba_tables where table_name = 'TEST';
OWNER
------------------------------
SYS
Ø dba and sysdba difference
dba, sysdba What is the role of the two systems in the illustrate this difference between what I need to say a few words before the creation of oracle service instance → · start to create an instance of → · create the database (system table space is required)
Start the process of loading the database instance starts → · → · open database
sysdba, oracle instance is managed, its existence does not depend on the entire database is fully started, as long as the instance starts, and he is there, in order to login as sysdba, loading the database, open the database. Only the database open, or fully activated the entire database, dba role in the existence of only the basis of!

相关文章
  • sys difference with the system 2010-04-05

    1) The most important difference, the importance of data stored in different sys] [all oracle data dictionary base tables and views are stored in the sys user, these base tables and views for the oracle operation is essential, by the maintenance of t

  • the difference with the system sys 2010-04-05

    1) The most important difference, the importance of data stored in different sys] [all oracle data dictionary base tables and views are stored in the sys user, these base tables and views for the oracle operation is essential, by the maintenance of t

  • linux difference between the System V and BSD 2011-09-07

    There are two ways to linux or unix startup mode: System V and BSD The biggest difference is: System V run levels can be defined for different services which start, for example: # 0 - off (do not put the initdefault is set to 0) # 1 - Single user mod

  • Library function calls and the difference between the system function call 2010-05-12

    Simple answer: library call is part of the language or application, and system calls are part of the operating system. (1) library function: Call the library to a program in the user address space to carry out its running time is "user" time is

  • Oracle sys and system differences 2011-04-27

    sys user: data dictionary owner (schema), With SYSDBA privileges, sys user password in the password file, You can start the database. system users: the general database administrator with DBA privileges, Password stored in the database, Can not start

  • Modify the oracle system.sys password 2010-04-07

    System authentication: $ Sqlplus / nolog $ Sql> connect / as sysdba $ Sql> alter user sys identified by sys; - to change the password for the SYS $ Sql> alter user system identified by manager;

  • alter system switch logfile and alter system archive log current difference 2010-09-18

    1 alter system switch logfile is forced log switch, not necessarily the current redo log file archiving (If the file opens automatically on archived redo log before, if automatic archiving is not turned on, not the current redo log file.) alter syste

  • Oracle: sysdba, dba, sysoper difference 2011-08-21

    difference between sys and system users 1) The most important difference, the importance of data stored in different sys oracle of all the base data dictionary tables and views are stored in the sys user, these base tables and views is essential for

  • Android system document 2013-01-05

    Android System Structure: Android 是一个开放的软件系统,为用户提供了丰富的移动设备开发功能,从下至上包括4 个层次,如图1 所示.其中第一层是Linux 内核层,包括Linux 操作系统及驱动,依赖于Linux2. 6 内核,不支持linux2.4 内核.如Android1.0(release 一1.0)使用inux2.6.25,Android1. 6(sdk 一1.6)使用Linux2.6.29.除了标准的Linux 内核外,Android 系统还增加了Bin

  • Several analytical winxp system special file 2010-04-17

    1, System Volume Information folder Open the System Restore after the production, and it set the restore point after saving a record of all operations of the district information. Ntfs partition in the system would also like to only allow the System

  • Use sigar for processors. Memory. System Information 2010-04-27

    First, create a web project, in webroot / web-inf / lib, add the following libraries and packages under Written test categories: import org.hyperic.sigar.CpuPerc; import org.hyperic.sigar.Mem; import org.hyperic.sigar.Sigar; public class SigarTest (

  • Linux signal signal processing system 2010-07-16

    Original Address: http://blog.chinaunix.net/u2/63021/showart_1678393.html Linux programming signal is a very important part, this article details the basic concepts of signaling mechanism, Linux signal mechanism for the general implementation method,

  • system the user's actual permissions 2010-07-22

    Before a new database, by plsqldeveloper log on, use the system user, identity as SYSDBA, the result error: insufficient privileges (Permission denied). Choice but to let the user log in the implementation of sys grant sysdba to system users for the

  • linux system optimization 2011-05-25

    Overview 1. "/ Etc / profile" file 2. "Bdflush" parameter 3. "Ip_local_port_range" parameter 4. "/ Etc / nsswitch.conf" file 5. "/ Proc" file system 6. "Ulimit" parameter 1. "/ Etc / profile

  • Oralce数据导入出现(SYSTEM.PROC_AUDIT)问题处理方法 2014-04-05

    A数据库打开了审计,而导入到B数据库时,B数据库审计没有打开,数据库中没有SYSTEM.PROC_AUDIT对象,本文将此问题的解决方法,需要的朋友可以参考下 将A数据的USERNAME用户的数据导出后,再导入到B数据库中的USERNAME时,在USERNAME用户下在执行表数据查询时出现如下问题: ORA-06550: 第 1 行, 第 7 列: PLS-00201: 必须声明标识符 'SYSTEM.PROC_AUDIT' ORA-06550: 第 1 行, 第 7 列: PL/SQL: St

  • Spring-based Task Scheduling (5) 2010-03-20

    3 Task scheduling factors to be considered when If you intend to add in the application task scheduling capabilities, and that what you choose to use the scheduler, as well as what kind of operation mode, you should consider a number of factors. 3.1

  • doc window of a few people order 2010-04-02

    Copying books to: http://blog.lanyue.com/view/610/1089169.htm Common doc command Daquan dos and windows dos commands the biggest difference is that way of operation, So users need to remember large amounts of command and its format uses Fangfa, dos c

  • AIX on the backup tape 2010-03-31

    How to backup AIX on tape: Backup for a system administrator is very important and effective backup is not a panacea, but no backup is absolutely essential. Therefore, the backup system is the system administrator often needs to be done, including ro

  • Research Report on Oracle Advanced Replication of data 2010-04-14

    Research Report on Oracle replication data Kwan Chan Time :2010-2-9 Using the scene description: Have a database server running, in order not to affect the usage of the database, a station needs a new database server Kai, the original database data a

  • SOLARIS 20% of knowledge to solve the problem 80% 2010-08-02

    Ps-ef command under Solaris echo CMD column length of 80 characters limit / Usr / ucb / ps-auxww pargs-l 1314 20% 80% SOLARIS knowledge to solve problems Germany, Sun Microsystems Inc. Version History Version Date Description May 25, 2002 the first E