V$PWFILE_USERS 列出的详解是password文件里已授予sysdba、sysoper权限的图及用户，b2b供应网如果查询没有记录，区别那就有可能没有了password文件了，详解没有了密码文件当然sqlplus sys/xx as sysdba这种用sys用sysdba用户就无法登录了。图及下面介绍一下11g和12c的IT技术网区别v$pwfile_user视图。 一、详解v$pwfile_user表(11g) V$PWFILE_USERS lists all users in the password file,图及 and indicates whether the user has been granted the SYSDBA, SYSOPER, and SYSASM privileges.
SELECT * FROM v$pwfile_users ORDER BY username; 
二、 v$pwfile_user表(12c) V$PWFILE_USERS lists all users in the password file,区别 and indicates whether the user has been granted the SYSDBA, SYSOPER, SYSASM,SYSBACKUP, SYSDG, and SYSKM privileges. 
网站模板 |
喜欢
讨厌