5a.358. Users (OCI360_USERS) 5a.358. Users (OCI360_USERS)
| # | ID | NAME | DESCRIPTION | CAPA | CAPA | CAPABILI | CAPA | CAPA | CAPA | DEFINED_TAGS$ORACLE_TAGS$CREATEDBY | DEFINED_TAGS$ORACLE_TAGS$CREATED | TIME_CREATED | COMPARTMENT_ID | INAC | LIFECYCL | IS_MFA_A | EXTERNAL_IDENTIFIER | IDENTITY_PROVIDER_ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ocid1.user.oc1..000000000000000000000000000000000000000000000000000000000687 | oci360_user | Account used for OCI360 | true | true | true | true | true | true | [email protected] | 2020-05-20T13:55:23.462Z | 2020-05-20T13:55:23.535000+00:00 | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | ACTIVE | false | ||||
| 2 | ocid1.user.oc1..000000000000000000000000000000000000000000000000000000000688 | oracleidentitycloudservice/[email protected] | [email protected] | true | true | false | true | true | true | scim-service | 2020-03-03T23:38:04.277Z | 2020-03-03T23:38:04.496000+00:00 | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | ACTIVE | false | fc10ff2be16a40b68c4c30957ff66293 | ocid1.saml2idp.oc1..000000000000000000000000000000000000000000000000000000000643 | ||
| 3 | ocid1.user.oc1..000000000000000000000000000000000000000000000000000000000690 | [email protected] | [email protected] | Rodrigo Jorge | true | true | true | true | true | true | 2020-03-03T23:33:34.012000+00:00 | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | ACTIVE | false | |||||
| 4 | ocid1.user.oc1..000000000000000000000000000000000000000000000000000000000689 | [email protected] | [email protected] | Rodrigo Jorge | true | true | true | true | true | true | oracleidentitycloudservice/[email protected] | 2020-06-07T14:01:01.142Z | 2020-06-07T14:01:01.226000+00:00 | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | ACTIVE | false |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
NAME VARCHAR2(64)
EMAIL VARCHAR2(32)
DESCRIPTION VARCHAR2(32)
CAPABILITIES$CAN_USE_API_KEYS VARCHAR2(4)
CAPABILITIES$CAN_USE_AUTH_TOKENS VARCHAR2(4)
CAPABILITIES$CAN_USE_CONSOLE_PASSWORD VARCHAR2(8)
CAPABILITIES$CAN_USE_SMTP_CREDENTIALS VARCHAR2(4)
CAPABILITIES$CAN_USE_CUSTOMER_SECRET_KEYS VARCHAR2(4)
CAPABILITIES$CAN_USE_O_AUTH2_CLIENT_CREDENTIALS VARCHAR2(4)
DEFINED_TAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DEFINED_TAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
TIME_CREATED VARCHAR2(32)
COMPARTMENT_ID VARCHAR2(128)
INACTIVE_STATUS VARCHAR2(4)
LIFECYCLE_STATE VARCHAR2(8)
IS_MFA_ACTIVATED VARCHAR2(8)
EXTERNAL_IDENTIFIER VARCHAR2(32)
IDENTITY_PROVIDER_ID VARCHAR2(128)
SELECT t1.*
FROM OCI360_USERS t1;
4 rows selected.