Oracle 视图 DBA_PROFILES 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_PROFILES是用来查询关于数据库中的帐户的属性以及积分的详细情况的视图。
它主要信息包括：
1. PROFILE – 帐户所属的配置文件名称;
2. RESOURCE_NAME – 相关资源的名称;
3. RESOURCE_TYPE – 资源类型;
4. LIMIT – 资源限制;
5. INITIAL_DISK – 帐户接收到的初始远程磁盘授权;
6. EXTENDED_DISK – 帐户接收的可伸缩的远程磁盘授权;
7. USERNAME – 有关的用户的名称;
8. ENABLED – 指定是否已启用此配置文件;
9. DEFAULT_PROFILE – 该帐户是否有默认的配置文件;
10. PROFILE_ID – 配置文件的唯一标识。
使用：
1. 通过SELECT语句来读取视图内记录：
SELECT * FROM DBA_PROFILES;
2. 通过WHERE子句来检索指定条件的记录：
SELECT * FROM DBA_PROFILES WHERE USERNAME=’username’ AND LIMIT=’limit’;
官方英文解释
DBA_PROFILES displays all profiles and their limits.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Profile name |
|
|
|
|
Resource name |
|
|
|
Indicates whether the resource profile is a |
|
|
|
|
Limit placed on this resource for the profile |
|
|
|
|
Indicates whether the profile is common. Possible values:
|
|
|
|
|
Indicates whether the profile definition was inherited from another container ( |
|
|
|
|
Indicates whether the profile was created by an implicit application ( |
|
|
|
|
Indicates whether the profile was created by Oracle-supplied scripts ( Note that a profile created by Oracle-supplied scripts is local to all PDBs and can be changed inside a PDB to accommodate individual application requirements. |
|
|
|
|
Indicates whether the profile is a mandatory user profile ( See Also: The MANDATORY_USER_PROFILE initialization parameter |
Footnote 1 This column is available starting with Oracle Database 21c.
