Viewing Password File Members (49)

最新推荐文章于 2025-12-20 13:10:13 发布

转载最新推荐文章于 2025-12-20 13:10:13 发布 · 90 阅读

文章标签：

#数据库

本文介绍如何使用V$PWFILE_USERS视图来查看被授予SYSDBA或SYSOPER系统权限的用户。通过此视图可以了解到用户的登录权限详情。

Use the V$PWFILE_USERS view to see the users who have been granted SYSDBA or
SYSOPER system privileges for a database. The columns displayed by this view are as
follows:
USERNAME : This column contains the name of the user that is recognized by the
password file.
SYSDBA : If the value of this column is TRUE, then the user can log on with
SYSDBA system privileges.
SYSOPER : If the value of this column is TRUE, then the user can log on with
SYSOPER system privileges.

查看密码文件对象
通过视图 V$PWFILE_USERS 可查看赋予了sysdba与sysoper权限的用户

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-995392/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-995392/