Oracle 视图 USER_POLICY_GROUPS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图user_policy_groups是JDBC SYS视图,用于查看当前数据库中用户及其权限组。它可以显示指定用户的权限组,也可以显示所有现有的权限组。
用法:
1.查看单个用户:
SELECT *
FROM user_policy_groups
WHERE user_name = ‘用户名’;
2.查看所有用户:
SELECT *
FROM user_policy_groups;
官方英文解释
USER_POLICY_GROUPS
describes the policy groups defined for the synonyms, tables, and views owned by the current user. Its columns (except for OBJECT_OWNER
) are the same as those in ALL_POLICY_GROUPS
.
See Also:
“ALL_POLICY_GROUPS”