The administrative account SYS is automatically created when a database is created. This account can perform all database administrative functions. The SYS schema stores the base tables and views for the data dictionary. These base tables and views are critical for the operation of Oracle Database. Tables in the SYS schema are manipulated only by the database and must never be modified by any user.The SYSTEM account is also automatically created when a database is created. The SYSTEM schema stores additional tables and views that display administrative information, and internal tables and views used by various Oracle Database options and tools. Never use the SYSTEM schema to store tables of interest to nonadministrative users.
ACMAIN_CHM Never use the SYSTEM schema to store tables of interest to nonadministrative users. 这句什么意思? 不许用SYSTEM方案去存储非管理员用户可以访问的表 ??
systm用户拥有sysdba系统权限吗?如果是的话,那system不就权力很大了吗?下面是我在自己电脑上的测试例子:SQL> conn system/admin Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 Connected as system SQL> select * from user_sys_privs; USERNAME PRIVILEGE ADMIN_OPTION ------------------------------ ---------------------------------------- ------------ SYSTEM CREATE TABLE NO SYSTEM SELECT ANY TABLE NO SYSTEM GLOBAL QUERY REWRITE NO SYSTEM UNLIMITED TABLESPACE YES SYSTEM CREATE MATERIALIZED VIEW NO
sys用户具有“SYSDBA”或者“SYSOPER”系统权限,登陆em也只能用这两个身份,不能用normal。以sys用户登陆Oracle,执行select * from V_$PWFILE_USERS;可查询到具有sysdba权限的用户,如:SQL> select * from V_$PWFILE_USERS;
USERNAME SYSDBA SYSOPER
SYS TRUE TRUE更多详细内容可以参见下面的链接
http://blog.csdn.net/wh62592855/archive/2009/11/09/4791879.aspx
用system 加as sysdba的时候
在你登陆进去你可以使用
show user
命令来查看当前登录用户
你会发现其实是SYS 而不是SYSTEM
This account can perform all database administrative functions. The SYS schema
stores the base tables and views for the data dictionary. These base tables and views
are critical for the operation of Oracle Database. Tables in the SYS schema are
manipulated only by the database and must never be modified by any user.The SYSTEM account is also automatically created when a database is created. The
SYSTEM schema stores additional tables and views that display administrative
information, and internal tables and views used by various Oracle Database options
and tools. Never use the SYSTEM schema to store tables of interest to
nonadministrative users.
Never use the SYSTEM schema to store tables of interest to
nonadministrative users. 这句什么意思? 不许用SYSTEM方案去存储非管理员用户可以访问的表 ??
对我有用[0] 丢个板砖[0] 引用 举报 管理 TOP 精华推荐:没有备份的情况下对control进行了误删除,请问如何恢复
wh62592855
(谦虚的菜鸟) 等 级:
#4楼 得分:0回复于:2009-12-20 19:26:57sys和system用户区别 1)最重要的区别,存储的数据的重要性不同 sys所有oracle的数据字典的基表和视图都存放在sys用户中,这些基表和视图对于oracle的运行是至关重要的,由数据库自己维护,任何用户都不能手动更改。sys用户拥有dba,sysdba,sysoper等角色或权限,是oracle权限最高的用户。 system用户用于存放次一级的内部数据,如oracle的一些特性或工具的管理信息。system用户拥有普通dba角色权限。 2)其次的区别,权限的不同 system用户只能用normal身份登陆em,除非你对它授予了sysdba的系统权限或者syspoer系统权限。
sys用户具有“SYSDBA”或者“SYSOPER”系统权限,登陆em也只能用这两个身份,不能用normal。 以sys用户登陆Oracle,执行select * from V_$PWFILE_USERS;可查询到具有sysdba权限的用户,如: SQL> select * from V_$PWFILE_USERS;
USERNAME SYSDBA SYSOPER
SYS TRUE TRUE 更多详细内容可以参见下面的链接
http://blog.csdn.net/wh62592855/archive/2009/11/09/4791879.aspx
前面将的比较清楚,也可以看下我的blog: 关于用户和角色的相关内容,可以帮助理解http://blog.csdn.net/tianlesoftware/archive/2009/11/08/4786956.aspx
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
thesecretblue
你复制??
我用system可以作为sysdba登陆em...不知道为什么?
什么提示?你是说哪个错误?
我用system作为sysdba可以登陆enterprise manager console的
还有system不能作为sysoper登陆enterprise manager console..
我用的是vista 10g Release 2
Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Connected as system
SQL> select * from user_sys_privs;
USERNAME PRIVILEGE ADMIN_OPTION
------------------------------ ---------------------------------------- ------------
SYSTEM CREATE TABLE NO
SYSTEM SELECT ANY TABLE NO
SYSTEM GLOBAL QUERY REWRITE NO
SYSTEM UNLIMITED TABLESPACE YES
SYSTEM CREATE MATERIALIZED VIEW NO