3.138 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_USERS
describes all users of the database, and contains more columns thanALL_USERS
. -
USER_USERS
describes 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 |
See Also:
-
Using Oracle Sharding for more information about sharded database management