Oracle 视图 ALL_USERS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_USERS是Oracle系统表的一部分，它可以用来查出被授权的所有Oracle用户的角色，账户名等信息。可以通过该功能来获取全部数据库用户的信息，以便更好的管理和控制数据库中的账户和角色信息。
使用ALL_USERS视图可以使用以下语法查询：
SELECT *
FROM ALL_USERS;
即可获得所有分配给数据库用户的信息，例如用户名，位置，用户创建日期，用户角色等等。
官方英文解释
ALL_USERS lists all users of the database visible to the current user.
This view does not describe the users (see the related views).
Related Views
DBA_USERSdescribes all users of the database, and contains more columns thanALL_USERS.USER_USERSdescribes the current user, and contains more columns thanALL_USERS.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
| Name of the user |
|
|
| ID number of the user |
|
|
| User creation date |
|
| Indicates whether a given user is common. Possible values:
| |
|
| Denotes whether the user was created, and is maintained, by Oracle-supplied scripts (such as catalog.sql or catproc.sql). A user for which this column has the value | |
|
| Indicates whether the user definition was inherited from another container ( | |
|
| Default collation for the user’s schema | |
|
| Indicates whether this user is a common user created by an implicit application ( | |
|
| In a sharded database, the value in this column indicates whether the user was created with shard DDL enabled. The possible values are:
In a non-sharded database, the value in this column is always | |
|
| In a federated sharded database, the value in this column indicates whether the user is an external shard user ( In other types of databases, the value in this column is always |
Footnote 1 This column is available starting with Oracle Database 21c.
See Also:
“DBA_USERS”
“USER_USERS”
Using
Oracle Sharding for more information about sharded database management
编辑：编程语言
标签：用户,信息,角色,视图,账户