Oracle教程 2023-02-23

Oracle 视图 ALL_GOLDENGATE_PRIVILEGES 官方解释，作用，如何使用详细说明

本站中文解释

Oracle的视图ALL_GOLDENGATE_PRIVILEGES指的是所有用户和应用程序中已经授予它们的Oracle GoldenGate权限的汇总，其中包括用户名、对象的名字、权限、储存过程和函数及在其中授予的权限等等。它是一个易于使用的资源，可以管理相关的权限和审核这些权限。

使用这个视图，可以筛选出列出所有已授予应用程序和用户的Oracle GoldenGate权限，以便进行进一步的分析和审核，并且在需要授予、重新授予或者收回权限时可以执行更加可靠和快速的操作。

使用ALL_GOLDENGATE_PRIVILEGES视图可以通过以下步骤：

1. 执行一个SELECT语句，查询视图中的所有详细权限信息，比如SELECT * FROM all_goldengate_privileges;

2. 如果想要查询某个特定的用户权限，可以执行一个带有WHERE子句的SELECT语句，比如SELECT * FROM all_goldengate_privileges WHERE username = ‘user1’;

3. 也可以按照对象名称对权限进行筛选，比如SELECT * FROM all_goldengate_privileges WHERE object_name = ‘my_table’;

4. 通过添加排序关键字，也可以按特定顺序进行数据排列，比如SELECT * FROM all_goldengate_privileges ORDER BY username;

官方英文解释

ALL_GOLDENGATE_PRIVILEGES displays details about Oracle GoldenGate privileges for the user. Oracle GoldenGate privileges are granted using the DBMS_GOLDENGATE_AUTH package.

Related Views

DBA_GOLDENGATE_PRIVILEGES displays details about Oracle GoldenGate privileges for all users who have been granted Oracle GoldenGate privileges.
USER_GOLDENGATE_PRIVILEGES displays details about Oracle GoldenGate privileges. This view does not display the USERNAME column.

Column	Datatype	NULL	Description
`USERNAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the user that is granted the privilege
`PRIVILEGE_TYPE`	`VARCHAR2(7)`		Type of privilege granted: `APPLY` `CAPTURE` *: Both `APPLY` and `CAPTURE`
`GRANT_SELECT_PRIVILEGES`	`VARCHAR2(3)`		Shows whether the set of privileges granted to the administrator make the administrator a full privilege administrator or a minimum privilege administrator: `YES`: The administrator has the `SELECT_CATALOG_ROLE` role and other privileges, is considered a full privilege administrator, and can manage any Oracle GoldenGate configuration. `NO`: The administrator is considered a minimum privilege administrator, and can only manage Oracle GoldenGate configurations where the apply_user or capture_user (based on the `PRIVILEGE_TYPE` column) matches the username.
`CREATE_TIME`	`TIMESTAMP(6)`		Time at which the privilege was granted
`LAST_MODIFIED`	`TIMESTAMP(6)`		Time at which the privilege was last modified

本站中文解释

官方英文解释

相关推荐