{"id":9704,"date":"2017-01-24T21:39:10","date_gmt":"2017-01-24T20:39:10","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/"},"modified":"2017-01-24T21:39:10","modified_gmt":"2017-01-24T20:39:10","slug":"exadata-express-cloud-service-pdb_admin-privileges","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/","title":{"rendered":"Exadata Express Cloud Service: PDB_ADMIN privileges"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nI usually explain that the main point about Multitenant Architecture is the separation of roles between a system DBA who manages the container, and is responsible for its availability, and application DBA who owns all the application objects, and is responsible for data integrity and performance. The Exadata Express Cloud Service is the implementation of that: a CDB managed by Oracle and a PDB that you administrate. But the fact that the system is shared, over the internet, brings the necessity for new limitations. Let&#8217;s see what you can do or not as a PDB administrator.<br \/>\n<!--more--><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureEXCS024.png\"><img loading=\"lazy\" decoding=\"async\" style=\"float:left;margin-right:20px\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureEXCS024.png\" alt=\"CaptureEXCS024\" width=\"300\" height=\"204\" class=\"alignnone size-medium wp-image-14425\" \/><\/a> When you create a pluggable database you need to provide a local user and its password. When you create an Exadata Express Cloud Service, the PDM_ADMIN user is created but the account is locked. You need to provide your password in order to unlock it. Then, this PDB_ADMIN is the only user for which you know the password.<\/p>\n<p>But what really means &#8216;PDB administrator&#8217;? Which privileges do you have?<\/p>\n<h3>System privileges<\/h3>\n<p>PDB_ADMIN looks like a DBA. He is not granted &#8216;DBA&#8217; but &#8216;PDB_DBA&#8217; and many other roles.<br \/>\nLet&#8217;s see which system privileges are not granted, either directly or though a path of roles:<\/p>\n<pre><code>with my_user_roles(grantee,granted_role) as (\nselect grantee,granted_role from dba_role_privs where grantee='PDB_ADMIN' union all select r.grantee,r.granted_role from dba_role_privs r join my_user_roles u on r.grantee =u.granted_role\n) select listagg(privilege,',')within group(order by privilege) from (\nselect distinct privilege from dba_sys_privs minus select distinct privilege from dba_sys_privs where grantee in (select granted_role from my_user_roles));\n&nbsp;\nLISTAGG(PRIVILEGE,',')WITHINGROUP(ORDERBYPRIVILEGE)\n---------------------------------------------------                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              \nADMINISTER KEY MANAGEMENT,BACKUP ANY TABLE,BECOME USER,CREATE ANY CREDENTIAL,CREATE ANY DIRECTORY,CREATE ANY JOB,CREATE ANY LIBRARY,CREATE CREDENTIAL,CREATE DATABASE LINK,CREATE EXTERNAL JOB,CREATE LIBRARY,CREATE PUBLIC DATABASE LINK,DROP ANY DIRECTORY,DROP PUBLIC DATABASE LINK,EM EXPRESS CONNECT,EXECUTE ANY CLASS,EXECUTE ANY PROGRAM,EXEMPT ACCESS POLICY,EXEMPT DDL REDACTION POLICY,EXEMPT DML REDACTION POLICY,EXEMPT REDACTION POLICY,EXPORT FULL DATABASE,FLASHBACK ANY TABLE,FLASHBACK ARCHIVE ADMINISTER,FORCE TRANSACTION,GRANT ANY PRIVILEGE,GRANT ANY ROLE,IMPORT FULL DATABASE,INHERIT ANY PRIVILEGES,LOGMINING,MANAGE ANY FILE GROUP,MANAGE FILE GROUP,MANAGE SCHEDULER,SELECT ANY TRANSACTION,UNLIMITED TABLESPACE,USE ANY JOB RESOURCE,USE ANY SQL TRANSLATION PROFILE  \n<\/code><\/pre>\n<p>So your PDB_ADMIN has some system privileges. For example you can gather system statistics:<\/p>\n<pre><code>\nSQL&gt; exec dbms_stats.gather_system_stats;\nPL\/SQL procedure successfully completed.\n&nbsp;\nSNAME          PNAME       PVAL1  PVAL2             \n-----          -----       -----  -----\nSYSSTATS_INFO  STATUS             COMPLETED         \nSYSSTATS_INFO  DSTART             01-24-2017 19:48  \nSYSSTATS_INFO  DSTOP              01-24-2017 19:48  \nSYSSTATS_INFO  FLAGS       1                        \nSYSSTATS_MAIN  CPUSPEEDNW  3097                     \nSYSSTATS_MAIN  IOSEEKTIM   7                        \nSYSSTATS_MAIN  IOTFRSPEED  4096                   \n<\/code><\/pre>\n<p>but you cannot create database links or directories, which may be considered as application objects:<\/p>\n<pre><code>\ncreate directory mydir as '\/tmp'\nORA-01031: insufficient privileges\n&nbsp;\nSQL&gt; create database link mydblink connect to pdb_admin identified by \"Ach1z0#d\" using '\/\/localhost';\nORA-01031: insufficient privileges\n<\/code><\/pre>\n<p>What you should understand is that you have a PDB, in a shared CDB, it is yours and you can do whatever you want as long as it has no side effects on your neighbours. You will see that communication with the external world (network, filesystem, host server) are very limited.<\/p>\n<h3>Lockdown profiles<\/h3>\n<p>Now we will see that the privileges we have are going beyond those that you can see in DBA_SYS_PRIVS and DBA_ROLE_PRIVS.<\/p>\n<p>From my query above, I have the ALTER SYSTEM privilege, so I can change some parameters:<\/p>\n<pre><code>\nSQL&gt; alter system set temp_undo_enabled=true;\nSystem SET altered.\nSQL&gt; alter system set cursor_sharing=exact;\nSystem SET altered.\n<\/code><\/pre>\n<p>However, some parameters cannot be set:<\/p>\n<pre><code>\nSQL&gt; alter session set max_idle_time=60;\nORA-01031: insufficient privileges\nSQL&gt; alter system set sga_target=3G;\nORA-01031: insufficient privileges\nSQL&gt; alter system set sql_trace=true;\nORA-01031: insufficient privileges\n<\/code><\/pre>\n<p>and most of the other ALTER SYSTEM statements are forbidden:<\/p>\n<pre><code>\nSQL&gt; alter system flush shared_pool;\nORA-01031: insufficient privileges\n<\/code><\/pre>\n<p>This is forbidden by a multitenant lockdown profile, which gives a finer grain than privileges: it disables some statements, or statements clauses or options. The bad thing about it is that you don&#8217;t know what you are allowed or not. Always the same &#8216;insufficient privileges&#8217; and the detail is stored only on CDB$ROOT. From the PDB:<\/p>\n<pre><code>\nSQL&gt; select * from dba_lockdown_profiles;\nno rows selected\n<\/code><\/pre>\n<p>the only thing that can be known from the PDB is the name of the lockdown profile:<\/p>\n<pre><code>\nSQL&gt; show parameter lockdown\nNAME         TYPE   VALUE \n------------ ------ ----- \npdb_lockdown string S20   \n<\/code><\/pre>\n<p>That&#8217;s not a coincidence. I&#8217;m on a &#8216;S20&#8217; service (30 GB storage, 3GB SGA) and the lockdown profile is associated with the service level.<br \/>\nOf course, you cannot change it:<\/p>\n<pre><code>\nSQL&gt; alter system set pdb_lockdown='S50';\nORA-32017: failure in updating SPFILE\nORA-01031: insufficient privileges\n&nbsp;\nSQL&gt; alter system set pdb_lockdown='S50' scope=memory;\nORA-01031: insufficient privileges\n<\/code><\/pre>\n<p>Always the same message&#8230; Before 12<em>c<\/em>R2 you just query the system privileges to understand why you get this message. Now, you need to ask to your CDB administrator. Of course, for Exadata Express Cloud Service, this is documented in <a href=\"https:\/\/docs.oracle.com\/en\/cloud\/paas\/exadata-express-cloud\/csdbk\/feature-restrictions-and-limitations.html\">limitations<\/a>.<\/p>\n<p>Lockdown profiles are not only for ALTER SYSTEM.<br \/>\nYou have a few things that you cannot do with ALTER SESSION, such as setting SQL Trace, any Event, and any underscore parameter is also forbidden. ALTER DATABASE and ALTER PLUGGABLE DATABASE allow only OPEN\/CLOSE, or change default edition, default tablespace and temporary tablespace. On datafiles, you can only resize  and set autoextend on\/off. You can also set the time zone.<\/p>\n<p>Well, I&#8217;m not completely sure about CLOSE:<\/p>\n<pre><code>\nSQL&gt; alter pluggable database close immediate;\nORA-01031: insufficient privileges\nalter pluggable database open\nORA-65019: pluggable database EPTDOJVM1KG already open\n<\/code><\/pre>\n<p>Lockdown profiles goes beyond enabling or disable statements. It can disable a few features that you see mentioned in &#8216;limitations&#8217;: you can&#8217;t create a manual AWR snapshot, can&#8217;t access the OS files by any way (UTL_FILE is disabled), can&#8217;t use any network protocol (UTL_TCP, UTL_MAIL,&#8230;)<\/p>\n<h3>So what?<\/h3>\n<p>I&#8217;m a DBA and connecting to a database where I&#8217;m not SYSDBA is a bit frustrating. PDB_ADMIN is granted SYSOPER but is locked in the password file. I&#8217;ve unlocked PDB_ADMIN but it is still EXPIRED &amp; LOCKED in password file;<\/p>\n<pre><code>\nSQL&gt; select * from dba_users where username='PDB_ADMIN';\n&nbsp;\nUSERNAME   USER_ID  PASSWORD  ACCOUNT_STATUS  LOCK_DATE  EXPIRY_DATE           DEFAULT_TABLESPACE  TEMPORARY_TABLESPACE  LOCAL_TEMP_TABLESPACE  CREATED               PROFILE  INITIAL_RSRC_CONSUMER_GROUP  EXTERNAL_NAME  PASSWORD_VERSIONS  EDITIONS_ENABLED  AUTHENTICATION_TYPE  PROXY_ONLY_CONNECT  COMMON  LAST_LOGIN                                     ORACLE_MAINTAINED  INHERITED  DEFAULT_COLLATION  IMPLICIT\n--------   -------  --------  --------------  ---------  -----------           ------------------  --------------------  ---------------------  -------               -------  ---------------------------  -------------  -----------------  ----------------  -------------------  ------------------  ------  ----------                                     -----------------  ---------  -----------------  --------\nPDB_ADMIN  94                 OPEN                       22-JUL-2017 19:17:41  SYSEXT              TEMP                  TEMP                   27-JUL-2016 17:05:02  DEFAULT  DEFAULT_CONSUMER_GROUP                      11G 12C            N                 PASSWORD             N                   NO      24-JAN-17 08.46.02.000000000 PM EUROPE\/BERLIN  N                  NO         USING_NLS_COMP     NO\n&nbsp;\nSQL&gt; select * from v$pwfile_users where username='PDB_ADMIN';\n&nbsp;\nUSERNAME   SYSDBA  SYSOPER  SYSASM  SYSBACKUP  SYSDG  SYSKM  ACCOUNT_STATUS    PASSWORD_PROFILE  LAST_LOGIN  LOCK_DATE             EXPIRY_DATE           EXTERNAL_NAME  AUTHENTICATION_TYPE  COMMON  CON_ID\n--------   ------  -------  ------  ---------  -----  -----  --------------    ----------------  ----------  ---------             -----------           -------------  -------------------  ------  ------\nPDB_ADMIN  FALSE   TRUE     FALSE   FALSE      FALSE  FALSE  EXPIRED &amp; LOCKED  DEFAULT                       07-JAN-2017 04:47:03  07-JAN-2017 04:47:03                 PASSWORD             NO      47\n<\/code><\/pre>\n<p>Keep in mind that this service is not for system DBA. You have the DBaaS for this. This is Oracle managed PDBaaS for developers and developers will get lot of freedom here: ability to test any feature, any optimizer setting, etc. This is a lot more than what Amazon RDS allows. You don&#8217;t have file or network access, but this is for small databases and it is totally integrated with SQL Developer to move data. No sql trace, no tkprof, but you have SQL Monitor. This is a very interesting platform for development small projects, 12<em>c<\/em>R2 features testing or prototypes. Very easy and fast to start. You can connect and code with APEX, .Net, Java, OCI&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . I usually explain that the main point about Multitenant Architecture is the separation of roles between a system DBA who manages the container, and is responsible for its availability, and application DBA who owns all the application objects, and is responsible for data integrity and performance. The Exadata Express Cloud Service [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":9706,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[220,135,1020,64,96,66,223],"type_dbi":[],"class_list":["post-9704","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-cdb","tag-cloud","tag-excs","tag-multitenant","tag-oracle","tag-pdb","tag-pluggable-databases"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Exadata Express Cloud Service: PDB_ADMIN privileges - dbi Blog<\/title>\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\/exadata-express-cloud-service-pdb_admin-privileges\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exadata Express Cloud Service: PDB_ADMIN privileges\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . I usually explain that the main point about Multitenant Architecture is the separation of roles between a system DBA who manages the container, and is responsible for its availability, and application DBA who owns all the application objects, and is responsible for data integrity and performance. The Exadata Express Cloud Service [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-24T20:39:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureEXCS024-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1023\" \/>\n\t<meta property=\"og:image:height\" content=\"695\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"7 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\/exadata-express-cloud-service-pdb_admin-privileges\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Exadata Express Cloud Service: PDB_ADMIN privileges\",\"datePublished\":\"2017-01-24T20:39:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/\"},\"wordCount\":795,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureEXCS024-1.png\",\"keywords\":[\"CDB\",\"Cloud\",\"EXCS\",\"multitenant\",\"Oracle\",\"PDB\",\"Pluggable Databases\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/\",\"name\":\"Exadata Express Cloud Service: PDB_ADMIN privileges - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureEXCS024-1.png\",\"datePublished\":\"2017-01-24T20:39:10+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureEXCS024-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureEXCS024-1.png\",\"width\":1023,\"height\":695},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exadata Express Cloud Service: PDB_ADMIN privileges\"}]},{\"@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":"Exadata Express Cloud Service: PDB_ADMIN privileges - dbi Blog","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\/exadata-express-cloud-service-pdb_admin-privileges\/","og_locale":"en_US","og_type":"article","og_title":"Exadata Express Cloud Service: PDB_ADMIN privileges","og_description":"By Franck Pachot . I usually explain that the main point about Multitenant Architecture is the separation of roles between a system DBA who manages the container, and is responsible for its availability, and application DBA who owns all the application objects, and is responsible for data integrity and performance. The Exadata Express Cloud Service [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/","og_site_name":"dbi Blog","article_published_time":"2017-01-24T20:39:10+00:00","og_image":[{"width":1023,"height":695,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureEXCS024-1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Exadata Express Cloud Service: PDB_ADMIN privileges","datePublished":"2017-01-24T20:39:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/"},"wordCount":795,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureEXCS024-1.png","keywords":["CDB","Cloud","EXCS","multitenant","Oracle","PDB","Pluggable Databases"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/","url":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/","name":"Exadata Express Cloud Service: PDB_ADMIN privileges - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureEXCS024-1.png","datePublished":"2017-01-24T20:39:10+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureEXCS024-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureEXCS024-1.png","width":1023,"height":695},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-pdb_admin-privileges\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Exadata Express Cloud Service: PDB_ADMIN privileges"}]},{"@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\/9704","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=9704"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9704\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/9706"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9704"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}