{"id":18,"date":"2008-09-22T16:30:35","date_gmt":"2008-09-22T20:30:35","guid":{"rendered":"http:\/\/dbtricks.com\/?p=18"},"modified":"2008-09-22T16:31:27","modified_gmt":"2008-09-22T20:31:27","slug":"how-to-enable-operating-system-authentication-on-oracle-xe","status":"publish","type":"post","link":"https:\/\/dbtricks.com\/?p=18","title":{"rendered":"How to enable Operating System authentication on Oracle XE"},"content":{"rendered":"<p>OS authentication is not enabled by default in Oracle XE. To allow the use of OPS$ users, open sql plus (All Programs -&gt; Oracle Database 10g Express Edition -&gt; Run SQL Command Line) and run the following command:<br \/>\n<strong>alter system set os_authent_prefix=OPS$ scope=spfile;<\/strong><\/p>\n<p>Restart the DB:<br \/>\n<strong>shutdown immediate<br \/>\nStartup<\/strong><\/p>\n<p>To Create the OS user:<\/p>\n<p><strong>CREATE USER &#8220;OPS$DOMAIN\\DOMAINUSER&#8221; PROFILE<\/strong><\/p>\n<p><strong>&#8220;DEFAULT&#8221; IDENTIFIED EXTERNALLY DEFAULT<\/strong><\/p>\n<p><strong>TABLESPACE &#8220;TABLESPACENAME&#8221;<\/strong><\/p>\n<p><strong>TEMPORARY TABLESPACE &#8220;TEMPTABLESPACENAME&#8221; ACCOUNT<\/strong><\/p>\n<p><strong>UNLOCK;<\/strong><\/p>\n<p>You can grant\u00a0 the appropriate roles just like any other user<\/p>\n<p><strong>GRANT CONNECT, RESOURCE\u00a0 TO<\/strong><\/p>\n<p><strong>&#8220;OPS$ DOMAIN\\DOMAINUSER &#8220;;<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>OS authentication is not enabled by default in Oracle XE. To allow the use of OPS$ users, open sql plus (All Programs -&gt; Oracle Database 10g Express Edition -&gt; Run SQL Command Line) and run the following command: alter system set os_authent_prefix=OPS$ scope=spfile; Restart the DB: shutdown immediate Startup To Create the OS user: CREATE [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[107,12,11],"class_list":["post-18","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle","tag-os-authentication","tag-xe"],"_links":{"self":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/18","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18"}],"version-history":[{"count":4,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/18\/revisions"}],"predecessor-version":[{"id":22,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/18\/revisions\/22"}],"wp:attachment":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}