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 |
|
|
|
Order number of the access control entry |
|
|
Start date of the access control entry |
|
|
|
End date of the access control entry |
|
|
|
Indicates whether the access control entry grants or denies the privilege |
|
|
|
Indicates whether the principal is inverted or not |
|
|
|
Principal the privilege is applied to |
|
|
|
Type of the principal |
|
|
|
Privilege |
See Also:
“USER_WALLET_ACES”