Get all database users
get
/database/security/users/
Returns records from DBA_USERS or ALL_USERS view depending on the role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
Request
Query Parameters
-
limit(optional): integer(int32)
The maximum number of records to return.
-
q(optional): string
Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.
Response
Supported Media Types
- application/json
200 Response
Description of all users in the database.
Root Schema : DatabaseUsers
Type:
Show Source
object-
count(optional):
integer
Total number of records in the current response.
-
hasMore(optional):
boolean
Indicates if there are more records to be retrieved.
-
items(optional):
array items
-
limit(optional):
integer
The actual page size limit on number of records applied by the server.
-
links(optional):
array links
-
offset(optional):
integer
The actual index from which the item resources are returned.
Nested Schema : items
Type:
Show Source
array-
Array of:
object DatabaseUsersItem
This object describes a database user. The list of attributes may vary depending on database version.
Nested Schema : DatabaseUsersItem
Type:
objectThis object describes a database user. The list of attributes may vary depending on database version.
Show Source
-
account_status(optional):
string
Account status.
-
all_shard(optional):
string
In a sharded database, the value in this column indicates whether the user was created with shard DDL enabled.
-
authentication_type(optional):
string
Indicates the authentication mechanism for the user.
-
common(optional):
string
Indicates whether a given user is common.
-
created(optional):
string
User creation date.
-
days_left(optional):
integer
Indicates the number of days left before the account expires. Can be a negative value if the account is expired.
-
default_collation(optional):
string
Default collation for the user???s schema.
-
default_tablespace(optional):
string
Default tablespace for data.
-
editions_enabled(optional):
string
Indicates whether editions have been enabled for the corresponding user (Y) or not (N).
-
expired_account(optional):
integer
When EXPIRY_DATE is in the past, 1, otherwise 0.
-
expiry_date(optional):
string
Date of expiration of the account.
-
external_name(optional):
string
User external name. For centrally managed users, if the database user mapping is an exclusive mapping, then this will be the directory service DN for the user. If this database user is a shared schema, it will be the DN of a group.
-
implicit(optional):
string
Indicates whether this user is a common user created by an implicit application (YES) or not (NO).
-
inherited(optional):
string
Indicates whether the user definition was inherited from another container (YES) or not (NO).
-
initial_rsrc_consumer_group(optional):
string
Initial resource consumer group for the user.
-
last_login(optional):
string
The time of the last user login.
-
links(optional):
array links
-
local_temp_tablespace(optional):
string
Default local temporary tablespace for the user.
-
lock_date(optional):
string
Date the account was locked if account status was LOCKED.
-
locked_account(optional):
integer
When LOCK_DATE is set, 1, otherwise 0.
-
open_account(optional):
integer
When ACCOUNT_STATUS = 'OPEN', 1, otherwise 0.
-
oracle_maintained(optional):
string
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.
-
password_versions(optional):
string
Shows the list of versions of the password hashes (also known as 'verifiers') existing for the account.
-
profile(optional):
string
User resource profile name.
-
proxy_only_connect(optional):
string
Indicates whether a user can connect directly (N) or whether the account can only be proxied (Y) by users who have proxy privileges for this account (that is, by users who have been granted the 'connect through' privilege for this account).
-
temporary_tablespace(optional):
string
Name of the default tablespace for temporary tables or the name of a tablespace group.
-
user_id(optional):
integer
ID number of the user.
-
username(optional):
string
Name of the user.