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).

Column Datatype NULL Description
USERNAME VARCHAR2(128) NOT NULL Name of the user
USER_ID NUMBER NOT NULL ID number of the user
CREATED DATE NOT NULL User creation date
COMMON VARCHAR2(3)  

Indicates whether a given user is common. Possible values:

  • YES if a user is common

  • NO if a user is local (not common)

ORACLE_MAINTAINED VARCHAR2(1)   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 Y must not be changed in any way except by running an Oracle-supplied script.
INHERITED VARCHAR2(3)   Indicates whether the user definition was inherited from another container (YES) or not (NO)
DEFAULT_COLLATION VARCHAR2(100)   Default collation for the user’s schema
IMPLICIT VARCHAR2(3)   Indicates whether this user is a common user created by an implicit application (YES) or not (NO)
ALL_SHARD VARCHAR2(3)  

In a sharded database, the value in this column indicates whether the user was created with shard DDL enabled. The possible values are:

  • YES: The user was created with shard DDL enabled. The user exists on all shards and the shard catalog.

  • NO: The user was created without shard DDL enabled. The user exists only in the database in which the user was created.

In a non-sharded database, the value in this column is always NO.

EXTERNAL_SHARD VARCHAR2(3)  

In a federated sharded database, the value in this column indicates whether the user is an external shard user (YES) or not (NO).

In other types of databases, the value in this column is always NO.

DICTIONARY_PROTECTED VARCHAR2(3)  

Indicates whether the user's schema is dictionary protected (YES) or not (NO)

See Also: Oracle AI Database Security Guide for more information about dictionary-protected schemas

See Also: