{"id":3837,"date":"2014-06-05T08:51:52","date_gmt":"2014-06-05T06:51:52","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/"},"modified":"2014-06-05T08:51:52","modified_gmt":"2014-06-05T06:51:52","slug":"oracle-system-schemas-vs-created-users","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/","title":{"rendered":"How to list all Oracle system schemas"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nDo you want to know which users come with the Oracle Database and which are the ones you have created? This is that not easy, especially prior to Oracle 12c. You know SYS and SYSTEM, but there are many others – especially when you have installed all options.<\/p>\n

And it is important to know them all, e. g. when you import or apply a password policy, etc.
\nLet’s see the options we have.<\/p>\n

12c shows Oracle maintained users<\/h3>\n

Oracle 12c has introduced the ORACLE_MAINTAINED in the DBA_USERS dictionary view.
\nIt is YES for the users created by oracle scripts (create database, calalog.sql, catproc.sql). So it’s the right place to check when you are in 12c.<\/p>\n

12c Common users<\/h3>\n

Oracle 12c has another column to distinguish the user commonality. This is for CDB: the oracle dictionary is stored in the root container, and each PDB have links to it. And what is nice is that even when in a non-cdb the column is at ‘YES’ for Oracle maintained users and at ‘NO’ for created users. (except if you create C## common users in a cdb).<\/p>\n

Default passwords<\/h3>\n

The table sys.default_pwd$ stores the default password hash value so that we can check which users can log with trivial password. Even if it includes all the Oracle maintained users, it has also some well known users which are not provided by database creation at all.<\/p>\n

Sysaux occupants<\/h3>\n

Another idea that I took from Martin Bach<\/a>\u00a0is to crosscheck check with v$sysaux_occupants. Some Oracle provided users are missing, but the nice thing is that there is a description for the schemas that are listed.<\/p>\n

Not exported by DataPump<\/h3>\n

DataPump maintains its own list of users for which the tables are not exported, and you can query sys.ku_noexp_tab for that. The old exp has also its list stored in sys.exu8usr. But both are not exhaustive.<\/p>\n

Another exclusion list is the one used by logical standby: system.logstdby$skip which may be used as well to crosscheck (only records with ‘action=0’ are relevant for schema exclusion).<\/p>\n

Let’s check all that on a 12c non-cdb database. Here is the query that crosscheck all than information with outer joins:<\/p>\n

select created,username,oracle_maintained,common,no_exp,no_expdp,no_sby,default_password,sysaux,occupant_desc\nfrom dba_users \nleft outer join \n (select distinct name username,'Y' no_expdp from sys.ku_noexp_tab where obj_type='SCHEMA') \n using(username)\nleft outer join (select distinct name username,'Y' no_exp from sys.exu8usr)\n using(username)\nleft outer join (select distinct name username,'Y' no_sby from system.logstdby$skip_support where action in (0,-1))\n using(username)\nleft outer join (select distinct user_name username,'Y' default_password from sys.default_pwd$)\n using(username)\nleft outer join (select schema_name username,'Y' sysaux,decode(count(*),1,min(occupant_desc)) occupant_desc from v$sysaux_occupants group by schema_name)\n using(username)\norder by created,username;\n<\/code><\/pre>\n
and the result, ordered by creation date so that you can check which users were created by the database creation:<\/p>\n
<\/code><\/pre>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
CREATED<\/th>\nUSER<\/th>\nORACLE
\nMAINTAINED<\/th>\n		COM-
\nMON<\/th>\n		NO
\nEXP<\/th>\n		NO
\nEXPDP<\/th>\n		NO
\nSBY<\/th>\n		DEF
\nPWD<\/th>\n		SYS
\nAUX<\/th>\n<\/tr>\n
28-FEB-14 08:25:02<\/td>\nAUDSYS<\/td>\nY<\/td>\nYES<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/tr>\n
28-FEB-14 08:25:02<\/td>\nSYS<\/td>\nY<\/td>\nYES<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/tr>\n
28-FEB-14 08:25:02<\/td>\nSYSBACKUP<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 08:25:02<\/td>\nSYSDG<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 08:25:02<\/td>\nSYSKM<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 08:25:02<\/td>\nSYSTEM<\/td>\nY<\/td>\nYES<\/td>\nY<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/tr>\n
28-FEB-14 08:25:05<\/td>\nOUTLN<\/td>\nY<\/td>\nYES<\/td>\nY<\/td>\n<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 08:29:33<\/td>\nGSMADMIN_INTERNAL<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 08:29:33<\/td>\nGSMUSER<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 08:29:43<\/td>\nDIP<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 08:30:39<\/td>\nXS$NULL<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 08:31:12<\/td>\nORACLE_OCM<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 08:39:55<\/td>\nDBSNMP<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/tr>\n
28-FEB-14 08:39:56<\/td>\nAPPQOSSYS<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 08:40:03<\/td>\nANONYMOUS<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 08:40:03<\/td>\nXDB<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/tr>\n
28-FEB-14 08:44:29<\/td>\nGSMCATUSER<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 08:53:38<\/td>\nWMSYS<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/tr>\n
28-FEB-14 08:55:31<\/td>\nOJVMSYS<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 08:59:58<\/td>\nCTXSYS<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/tr>\n
28-FEB-14 09:00:44<\/td>\nMDSYS<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/tr>\n
28-FEB-14 09:00:44<\/td>\nORDDATA<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/tr>\n
28-FEB-14 09:00:44<\/td>\nORDPLUGINS<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/tr>\n
28-FEB-14 09:00:44<\/td>\nORDSYS<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/tr>\n
28-FEB-14 09:00:44<\/td>\nSI_INFORMTN_SCHEMA<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/tr>\n
28-FEB-14 09:09:48<\/td>\nOLAPSYS<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/tr>\n
28-FEB-14 09:10:17<\/td>\nMDDATA<\/td>\nY<\/td>\nYES<\/td>\nY<\/td>\n<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 09:15:09<\/td>\nSPATIAL_WFS_ADMIN_USR<\/td>\nY<\/td>\nYES<\/td>\nY<\/td>\n<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 09:15:13<\/td>\nSPATIAL_CSW_ADMIN_USR<\/td>\nY<\/td>\nYES<\/td>\nY<\/td>\n<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 09:20:00<\/td>\nLBACSYS<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 09:20:16<\/td>\nAPEX_040200<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 09:20:16<\/td>\nAPEX_PUBLIC_USER<\/td>\nY<\/td>\nYES<\/td>\nY<\/td>\n<\/td>\n<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 09:20:16<\/td>\nFLOWS_FILES<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\n<\/td>\n<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 09:45:17<\/td>\nDVF<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
28-FEB-14 09:45:17<\/td>\nDVSYS<\/td>\nY<\/td>\nYES<\/td>\n<\/td>\nY<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
21-MAR-14 18:15:19<\/td>\nFRANCK<\/td>\nN<\/td>\nNO<\/td>\nY<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
09-APR-14 20:33:34<\/td>\nRMAN<\/td>\nN<\/td>\nNO<\/td>\nY<\/td>\n<\/td>\n<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
11-APR-14 09:04:55<\/td>\nDEMO<\/td>\nN<\/td>\nNO<\/td>\nY<\/td>\n<\/td>\n<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
23-APR-14 20:53:09<\/td>\nHR<\/td>\nN<\/td>\nNO<\/td>\nY<\/td>\n<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
23-APR-14 20:53:09<\/td>\nIX<\/td>\nN<\/td>\nNO<\/td>\nY<\/td>\n<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
23-APR-14 20:53:09<\/td>\nOE<\/td>\nN<\/td>\nNO<\/td>\nY<\/td>\n<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
23-APR-14 20:53:09<\/td>\nPM<\/td>\nN<\/td>\nNO<\/td>\nY<\/td>\n<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
23-APR-14 20:53:09<\/td>\nSH<\/td>\nN<\/td>\nNO<\/td>\nY<\/td>\n<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
25-APR-14 21:26:33<\/td>\nSQLTXADMIN<\/td>\nN<\/td>\nNO<\/td>\nY<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
25-APR-14 21:26:33<\/td>\nSQLTXPLAIN<\/td>\nN<\/td>\nNO<\/td>\nY<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
27-MAY-14 21:48:24<\/td>\nSCOTT<\/td>\nN<\/td>\nNO<\/td>\nY<\/td>\n<\/td>\nY<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
 
\nSo you see that the 12c columns are highly reliable. They include all users that have been created during the database creatio, but do not include the users that were created afterwards.
\nWhen not in 12c, the exclusion list coming from DataPump is quite good, but not exhaustive.
\nSometimes the most useful features are not those that change the future of database, but rather those little things that make life easier.
\nIn DBA_USERS, we have two very useful new columns: ORACLE_MAINTAINED and LAST_LOGIN. That is a great improvement.<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . Do you want to know which users come with the Oracle Database and which are the ones you have created? This is that not easy, especially prior to Oracle 12c. You know SYS and SYSTEM, but there are many others – especially when you have installed all options. And it is […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198,59],"tags":[455,96,209],"type_dbi":[],"class_list":["post-3837","post","type-post","status-publish","format-standard","hentry","category-database-management","category-oracle","tag-internals","tag-oracle","tag-oracle-12c"],"acf":[],"yoast_head":"\nHow to list all Oracle system schemas - dbi Blog<\/title>\n<meta name=\"description\" content=\"How to list Oracle system schemas when you want to know which users come with the Oracle Database and which are the ones you have created.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to list all Oracle system schemas\" \/>\n<meta property=\"og:description\" content=\"How to list Oracle system schemas when you want to know which users come with the Oracle Database and which are the ones you have created.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-06-05T06:51:52+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"How to list all Oracle system schemas\",\"datePublished\":\"2014-06-05T06:51:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/\"},\"wordCount\":853,\"commentCount\":0,\"keywords\":[\"internals\",\"Oracle\",\"Oracle 12c\"],\"articleSection\":[\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/\",\"name\":\"How to list all Oracle system schemas - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2014-06-05T06:51:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"How to list Oracle system schemas when you want to know which users come with the Oracle Database and which are the ones you have created.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to list all Oracle system schemas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to list all Oracle system schemas - dbi Blog","description":"How to list Oracle system schemas when you want to know which users come with the Oracle Database and which are the ones you have created.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/","og_locale":"en_US","og_type":"article","og_title":"How to list all Oracle system schemas","og_description":"How to list Oracle system schemas when you want to know which users come with the Oracle Database and which are the ones you have created.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/","og_site_name":"dbi Blog","article_published_time":"2014-06-05T06:51:52+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"How to list all Oracle system schemas","datePublished":"2014-06-05T06:51:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/"},"wordCount":853,"commentCount":0,"keywords":["internals","Oracle","Oracle 12c"],"articleSection":["Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/","name":"How to list all Oracle system schemas - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2014-06-05T06:51:52+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"How to list Oracle system schemas when you want to know which users come with the Oracle Database and which are the ones you have created.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-system-schemas-vs-created-users\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to list all Oracle system schemas"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3837","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3837"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3837\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3837"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}