{"id":6381,"date":"2024-03-14T04:10:55","date_gmt":"2024-03-14T04:10:55","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/"},"modified":"2025-08-02T02:54:08","modified_gmt":"2025-08-02T02:54:08","slug":"how-to-create-a-directory-and-grant-permissions-in-oracle","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/","title":{"rendered":"Oracle Directory: Create &#038; Grant Permissions"},"content":{"rendered":"<p>To create a DIRECTORY and grant permissions to it in an Oracle database, follow these steps:<\/p>\n<ol>\n<li>Firstly, log in to the Oracle database as a user with the CREATE ANY DIRECTORY system privilege.<\/li>\n<li>Create a DIRECTORY using the following SQL statement and specify the directory path that needs to be accessed.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">OR<\/span> REPLACE DIRECTORY my_dir <span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-string\">'\/path\/to\/directory'<\/span>;\r\n<\/code><\/pre>\n<ol>\n<li>Grant access permission to the newly created DIRECTORY using the following SQL statement:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">GRANT<\/span> READ, WRITE <span class=\"hljs-keyword\">ON<\/span> DIRECTORY my_dir <span class=\"hljs-keyword\">TO<\/span> your_user;\r\n<\/code><\/pre>\n<p>Please replace your_user with the user who needs access to the DIRECTORY.<\/p>\n<ol>\n<li>Finally, make sure that the newly created DIRECTORY has been properly authorized and is accessible. You can use the following SQL statement to query the users who have been granted permission to access the DIRECTORY:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> grantee, privilege\r\n<span class=\"hljs-keyword\">FROM<\/span> dba_tab_privs\r\n<span class=\"hljs-keyword\">WHERE<\/span> table_name <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'MY_DIR'<\/span>;\r\n<\/code><\/pre>\n<p>After completing the above steps, you have successfully created a DIRECTORY and granted it access permissions. You can now use this DIRECTORY in the database to access the specified directory path.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To create a DIRECTORY and grant permissions to it in an Oracle database, follow these steps: Firstly, log in to the Oracle database as a user with the CREATE ANY DIRECTORY system privilege. Create a DIRECTORY using the following SQL statement and specify the directory path that needs to be accessed. CREATE OR REPLACE DIRECTORY [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[7661,910,282,6011,125],"class_list":["post-6381","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-admin","tag-directory","tag-oracle","tag-permissions","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle Directory: Create &amp; Grant Permissions - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn to create Oracle directories and grant READ\/WRITE access with SQL commands. Step-by-step guide for database admins.\" \/>\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.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Directory: Create &amp; Grant Permissions\" \/>\n<meta property=\"og:description\" content=\"Learn to create Oracle directories and grant READ\/WRITE access with SQL commands. Step-by-step guide for database admins.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T04:10:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T02:54:08+00:00\" \/>\n<meta name=\"author\" content=\"Noah Thompson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Noah Thompson\" \/>\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:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/\"},\"author\":{\"name\":\"Noah Thompson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\"},\"headline\":\"Oracle Directory: Create &#038; Grant Permissions\",\"datePublished\":\"2024-03-14T04:10:55+00:00\",\"dateModified\":\"2025-08-02T02:54:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/\"},\"wordCount\":148,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Database Admin\",\"Directory\",\"Oracle\",\"Permissions\",\"SQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/\",\"name\":\"Oracle Directory: Create & Grant Permissions - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T04:10:55+00:00\",\"dateModified\":\"2025-08-02T02:54:08+00:00\",\"description\":\"Learn to create Oracle directories and grant READ\/WRITE access with SQL commands. Step-by-step guide for database admins.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Directory: Create &#038; Grant Permissions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\",\"name\":\"Noah Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"caption\":\"Noah Thompson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Directory: Create & Grant Permissions - Blog - Silicon Cloud","description":"Learn to create Oracle directories and grant READ\/WRITE access with SQL commands. Step-by-step guide for database admins.","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.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Directory: Create & Grant Permissions","og_description":"Learn to create Oracle directories and grant READ\/WRITE access with SQL commands. Step-by-step guide for database admins.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T04:10:55+00:00","article_modified_time":"2025-08-02T02:54:08+00:00","author":"Noah Thompson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Noah Thompson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/"},"author":{"name":"Noah Thompson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a"},"headline":"Oracle Directory: Create &#038; Grant Permissions","datePublished":"2024-03-14T04:10:55+00:00","dateModified":"2025-08-02T02:54:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/"},"wordCount":148,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Database Admin","Directory","Oracle","Permissions","SQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/","name":"Oracle Directory: Create & Grant Permissions - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T04:10:55+00:00","dateModified":"2025-08-02T02:54:08+00:00","description":"Learn to create Oracle directories and grant READ\/WRITE access with SQL commands. Step-by-step guide for database admins.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-directory-and-grant-permissions-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Directory: Create &#038; Grant Permissions"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a","name":"Noah Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","caption":"Noah Thompson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=6381"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6381\/revisions"}],"predecessor-version":[{"id":151141,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6381\/revisions\/151141"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=6381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=6381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=6381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}