Note that you should not change these users directly except modifying them by executing an Oracle-supplied script. Indicate whether the user was created and maintained by Oracle-supplied scripts ( Y). Specify if a user can connect directly ( N) or can only be proxied ( Y) by users who have proxy privileges for this account. The initial resource consumer group for the user The default local temporary tablespace for the user The default tablespace for temporary tables The date on which the account was locked if the account status is LOCKED This table explains the meaning of each column in the DBA_USERS view: ColumnĪccount status of the user. This link opens in a new tab/window, so you may refer back to this page. Choose your desired member type in Step 2 for detailed instructions. Once you have completed the form, you will be directed to the Oracle Academy Membership Registration process. The following statement returns all users in the Oracle Database, sorted by created date from the latest to the earliest: This link will take you to the Oracle Account Creation form. The DBA_USERS view describes all user in the Oracle database. In a non-sharded database, the value is always NO in this column. The user exists only in the database in which the user was created. NO: The user was created without shard DDL enabled.The user exists on all shards and the shard catalog. YES: The user was created with shard DDL enabled.In a sharded database, this column has either one of two possible values: YES and NO: Specifies the default collation for the schema of the user.ĭenotes if a user is a common user created by an implicit application ( YES) or not ( NO) Note that you should not change these users directly except modifying them by executing an Oracle-supplied script.ĭenotes where a user definition was inherited from another container ( YES) or not ( NO). Indicates whether the user was created and maintained by Oracle-supplied scripts ( Y). Specifies if a user is common ( YES) or Local ( NO) This table illustrates the meanings of each column in the ALL_USERS view: Column Code language: SQL (Structured Query Language) ( sql )

My oracle account