{"id":53936,"date":"2023-02-23T19:35:49","date_gmt":"2023-02-23T19:35:49","guid":{"rendered":"https:\/\/dbtut.com\/?p=53936"},"modified":"2023-02-23T19:36:54","modified_gmt":"2023-02-23T19:36:54","slug":"access-control-in-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/","title":{"rendered":"Access Control in Oracle"},"content":{"rendered":"

In today’s article, we will learn how to see users who access Oracle Database or users who get an error while accessing.<\/p>\n

SELECT username                               AS \"DB USER\",\r\n          os_username                         AS \"OS USER\",\r\n          userhost                            AS \"HOSTNAME\",\r\n          TO_CHAR (timestamp, 'DD\/MM\/YY HH24:MI:SS')\"TIMESTAMP\",\r\n          DECODE (\r\n              returncode,\r\n              00911, 'INCORRECT CHARACTER INPUT',\r\n              01004, 'ACCESS DISABLED',\r\n              01005, 'NULL PASSWORD ENTERED',\r\n              01017, 'WRONG USER OR PASSWORD',\r\n              01031, 'UNAUTHORIZED TRIAL',\r\n              01045, 'TRIAL WITHOUT CREATE SESSION AUTHORITY',\r\n              01918, 'NON-DB USER',\r\n              01920, 'NON-DB ROLE',\r\n              28000, 'LOCKED ACCOUNT TRIAL',\r\n              28001, 'PASSWORD EXPIRED',\r\n              28009, 'SYSDBA OR SYSOPER TRIAL')\r\n              AS return code\r\n     FROM SYS.DBA_AUDIT_SESSION\r\n    WHERE returncode != 0 AND -- timestamp > SYSDATE - 1 of 9 -- AND returncode IN (1017, 28000)\r\nORDER BY extended_timestamp DESC<\/pre>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will learn how to see users who access Oracle Database or users who get an error while accessing. SELECT username AS “DB USER”, os_username AS “OS USER”, userhost AS “HOSTNAME”, TO_CHAR (timestamp, ‘DD\/MM\/YY HH24:MI:SS’)”TIMESTAMP”, DECODE ( returncode, 00911, ‘INCORRECT CHARACTER INPUT’, 01004, ‘ACCESS DISABLED’, 01005, ‘NULL PASSWORD ENTERED’, 01017, ‘WRONG USER …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":574,"featured_media":53937,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-53936","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nAccess Control in Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will learn how to see users who access Oracle Database or users who get an error while accessing.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Access Control in Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will learn how to see users who access Oracle Database or users who get an error while accessing.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-23T19:35:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-23T19:36:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/02\/Ekran-goruntusu-2023-02-23-223428.png\" \/>\n\t<meta property=\"og:image:width\" content=\"628\" \/>\n\t<meta property=\"og:image:height\" content=\"307\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bu\u011fra PARLAYAN\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bu\u011fra PARLAYAN\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/\"},\"author\":{\"name\":\"Bu\u011fra PARLAYAN\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\"},\"headline\":\"Access Control in Oracle\",\"datePublished\":\"2023-02-23T19:35:49+00:00\",\"dateModified\":\"2023-02-23T19:36:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/\"},\"wordCount\":26,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/02\/Ekran-goruntusu-2023-02-23-223428.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/\",\"name\":\"Access Control in Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/02\/Ekran-goruntusu-2023-02-23-223428.png\",\"datePublished\":\"2023-02-23T19:35:49+00:00\",\"dateModified\":\"2023-02-23T19:36:54+00:00\",\"description\":\"In today's article, we will learn how to see users who access Oracle Database or users who get an error while accessing.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/02\/Ekran-goruntusu-2023-02-23-223428.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/02\/Ekran-goruntusu-2023-02-23-223428.png\",\"width\":628,\"height\":307},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Access Control in Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\",\"name\":\"Bu\u011fra PARLAYAN\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"caption\":\"Bu\u011fra PARLAYAN\"},\"description\":\"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.\",\"sameAs\":[\"http:\/\/www.bugraparlayan.com.tr\/\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Access Control in Oracle - Database Tutorials","description":"In today's article, we will learn how to see users who access Oracle Database or users who get an error while accessing.","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:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Access Control in Oracle - Database Tutorials","og_description":"In today's article, we will learn how to see users who access Oracle Database or users who get an error while accessing.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2023-02-23T19:35:49+00:00","article_modified_time":"2023-02-23T19:36:54+00:00","og_image":[{"width":628,"height":307,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/02\/Ekran-goruntusu-2023-02-23-223428.png","type":"image\/png"}],"author":"Bu\u011fra PARLAYAN","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bu\u011fra PARLAYAN","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/"},"author":{"name":"Bu\u011fra PARLAYAN","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2"},"headline":"Access Control in Oracle","datePublished":"2023-02-23T19:35:49+00:00","dateModified":"2023-02-23T19:36:54+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/"},"wordCount":26,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/02\/Ekran-goruntusu-2023-02-23-223428.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/","name":"Access Control in Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/02\/Ekran-goruntusu-2023-02-23-223428.png","datePublished":"2023-02-23T19:35:49+00:00","dateModified":"2023-02-23T19:36:54+00:00","description":"In today's article, we will learn how to see users who access Oracle Database or users who get an error while accessing.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/02\/Ekran-goruntusu-2023-02-23-223428.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/02\/Ekran-goruntusu-2023-02-23-223428.png","width":628,"height":307},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/02\/23\/access-control-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Access Control in Oracle"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2","name":"Bu\u011fra PARLAYAN","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","caption":"Bu\u011fra PARLAYAN"},"description":"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.","sameAs":["http:\/\/www.bugraparlayan.com.tr\/"],"url":"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/574"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=53936"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53936\/revisions"}],"predecessor-version":[{"id":53938,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53936\/revisions\/53938"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/53937"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=53936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=53936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=53936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}