{"id":166,"date":"2013-07-11T22:46:32","date_gmt":"2013-07-12T03:46:32","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=166"},"modified":"2026-02-07T15:29:24","modified_gmt":"2026-02-07T21:29:24","slug":"oracledb12c-new-feature-misc-security-changes","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2013\/166\/","title":{"rendered":"OracleDB12c New Feature: Misc Security Changes"},"content":{"rendered":"<p>Security in Oracle12c Database is enhanced, in this blog will try to identify few difference you would see compared with 11gR2.<\/p>\n<p><strong>SELECT ANY DICTIONARY<\/strong> privilege in 12c excludes access to the following tables with authentication information:<\/p>\n<ul>\n<li>DEFAULT_PWD$<\/li>\n<li>ENC$<\/li>\n<li>LINK$<\/li>\n<li>USER$<\/li>\n<li>USER_HISTORY$<\/li>\n<li>XS$VERIFIERS<\/li>\n<\/ul>\n<p><strong>AUDIT_TRAIL<\/strong> initialization parameter is set to DB by DBUA and DBCA utilities when a database is upgraded or created.<\/p>\n<p>In the previous versions when a user is granted the <strong>RESOURCE<\/strong> role, the <strong>UNLIMITED TABLESPACE<\/strong> privilege was granted. This is removed in 12c. If UNLIMITED TABLESPACE privilege required, it must be granted explicitly.<\/p>\n<p>The <strong>ORAPWD<\/strong> utility&#8217;s \u00a0IGNORECASE option is deprecated. The default is N. Similarly the <strong>SEC_CASE_SENSITIVE_LOGON<\/strong> parameter is deprecated as well.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Security in Oracle12c Database is enhanced, in this blog will try to identify few difference you would see compared with 11gR2. SELECT ANY DICTIONARY privilege in 12c excludes access to the following tables with authentication information: DEFAULT_PWD$ ENC$ LINK$ USER$ USER_HISTORY$ XS$VERIFIERS AUDIT_TRAIL initialization parameter is set to DB by DBUA and DBCA utilities when &#8230; <a title=\"OracleDB12c New Feature: Misc Security Changes\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2013\/166\/\" aria-label=\"Read more about OracleDB12c New Feature: Misc Security Changes\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[133],"tags":[],"class_list":["post-166","post","type-post","status-publish","format-standard","hentry","category-oracledb"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=166"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/166\/revisions"}],"predecessor-version":[{"id":3001,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/166\/revisions\/3001"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}