Gets a list of users for a Managed Database.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/users?name=<string>&sortBy=TIMECREATED&sortOrder=ASC&limit=10&page=<string>
Gets the list of users for the specified managedDatabaseId.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
name | string | A filter to return only resources that match the entire name. | |
sortBy | string | The field to sort information by. Only one sortOrder can be used. The default sort order | |
| for ‘TIMECREATED’ is descending and the default sort order for ‘NAME’ is ascending. | |||
| The ‘NAME’ sort order is case-sensitive. | |||
sortOrder | string | The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order. | |
limit | number | The maximum number of records returned in the paginated response. | |
page | string | The page token representing the page from where the next set of paginated results | |
| are retrieved. This is usually retrieved from a previous list call. | |||
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-named-credential-id | string | The OCID of the Named Credential. | |
Accept | string |
RESPONSES
status: OK
{"items":[{"name":"\u003cstring\u003e","status":"EXPIRED_GRACE","defaultTablespace":"\u003cstring\u003e","tempTablespace":"\u003cstring\u003e","timeCreated":"\u003cdateTime\u003e","profile":"\u003cstring\u003e","timeExpiring":"\u003cdateTime\u003e","timeLocked":"\u003cdateTime\u003e"},{"name":"\u003cstring\u003e","status":"OPEN","defaultTablespace":"\u003cstring\u003e","tempTablespace":"\u003cstring\u003e","timeCreated":"\u003cdateTime\u003e","profile":"\u003cstring\u003e","timeExpiring":"\u003cdateTime\u003e","timeLocked":"\u003cdateTime\u003e"}]}