WEB开发网
开发学院数据库Oracle 密码文件的恢复 || EM登录失败的解决 阅读

密码文件的恢复 || EM登录失败的解决

 2012-06-26 15:06:01 来源:WEB开发网   
核心提示:Grant succeeded.SQL> select * from v$pwfile_users;USERNAME SYSDB SYSOP-- - -SYS TRUE TRUESYSTEM FALSE TRUEWhen you connect with SY
Grant succeeded.
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP
------------------------------ ----- -----
SYS TRUE TRUE
SYSTEM FALSE TRUE
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
SQL> select * from system_privilege_map where name like '%SYS%';
PRIVILEGE NAME PROPERTY
---------- ---------------------------------------- ----------
-3 ALTER SYSTEM 0
-4 AUDIT SYSTEM 0
-83 SYSDBA 0
-84 SYSOPER 0

SQL> show user
USER is "SYS"
SQL> conn / as sysoper
Connected.
SQL> show user
USER is "PUBLIC"

上一页  1 2 

Tags:密码 文件 恢复

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接