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

本站中文解释

ST

1. Oracle视图DBA_WALLET_ACESST:

DBA_WALLET_ACESST是Oracle数据库中用于存储用户受钱包文件访问权限的视图。它由数据库系统管理器(DBA)运行,用于控制和管理用户对钱包文件的访问权限。

2. 用途:

DBA_WALLET_ACESST视图可用于控制用户对钱包文件的访问权限。用户可以从中检索关于它们的钱包文件的访问权限摘要,以及判断对它们的授权是否正确。

3. 如何使用:

(1)使用该视图的SELECT语句可以检索钱包访问权限的信息。

SELECT * FROM dba_wallet_acesst;

(2)删除用户特定的记录:

DELETE FROM dba_wallet_acesst WHERE wallet_name=’TEST_WALLET’;

官方英文解释

DBA_WALLET_ACES describes access control entries defined in wallet access control lists.

Related View

USER_WALLET_ACES describes the status of access control entries for the current user to access wallets through PL/SQL network utility packages. This view does not display the ACE_ORDER, START_DATE, END_DATE, GRANT_TYPE, INVERTED_PRINCIPAL, PRINCIPAL, or PRINCIPAL_TYPE columns.

Column Datatype NULL Description

WALLET_PATH

VARCHAR2(1000)

NOT NULL

Wallet path

ACE_ORDER

NUMBER

NOT NULL

Order number of the access control entry

START_DATE

TIMESTAMP(6)

Start date of the access control entry

END_DATE

TIMESTAMP(6)

End date of the access control entry

GRANT_TYPE

VARCHAR2(5)

Indicates whether the access control entry grants or denies the privilege

INVERTED_PRINCIPAL

VARCHAR2(3)

Indicates whether the principal is inverted or not

PRINCIPAL

VARCHAR2(128)

Principal the privilege is applied to

PRINCIPAL_TYPE

VARCHAR2(16)

Type of the principal

PRIVILEGE

VARCHAR2(128)

Privilege

See Also:

“USER_WALLET_ACES”


数据运维技术 » Oracle 视图 DBA_WALLET_ACES 官方解释,作用,如何使用详细说明