2013年(16)
分类: Oracle
2013-05-09 14:43:32
Values
Authentication Methods Available with Oracle Net Services:
none for no authentication methods, including Microsoft Windows native operating system authentication. WhenSQLNET.AUTHENTICATION_SERVICES is set to none, a valid user name and password can be used to access the database.
all for all authentication methods.
nts for Microsoft Windows native operating system authentication.
The following operations are authorized by the SYSDBA and SYSOPER system privileges:
System Privilege | Operations Authorized |
---|---|
SYSDBA |
Effectively, this system privilege allows a user to connect as user SYS. |
SYSOPER |
This privilege allows a user to perform basic operational tasks, but without the ability to look at user data. |
The manner in which you are authorized to use these privileges depends upon the method of authentication that you 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.
看官方的文档发现,sysoper权限不包括:修改字符集和不完全恢复的操作,其实还有很多系统视图是不能查看的