The maximum length of directory is 30 bytes. Specify the name of the directory object to be created. See Also: DROP DIRECTORY for information on removing a directory from the database Users who had previously been granted privileges on a redefined directory can still access the directory without being regranted the privileges. You can use this clause to change the definition of an existing directory without dropping, re-creating, and regranting database object privileges previously granted on the directory. Specify OR REPLACE to re-create the directory database object if it already exists. For example, an error occurs if sample user hr is granted READ privilege on the directory object but the corresponding operating system directory does not have READ permission defined for Oracle Database processes.ĭescription of the illustration create_directory.gif Privileges granted for the directory are created independently of the permissions defined for the operating system directory, and the two may or may not correspond exactly. Your system or database administrator must ensure that the operating system directory has the correct read and write permissions for Oracle Database processes.
They let the grantee determine whether the external table agent can write a log file or a bad file to the directory.įor file storage, you must also create a corresponding operating system directory, an ASM disk group, or a directory within an ASM disk group. WRITE privileges on a directory are useful in connection with external tables. The DBA can also grant these privileges to other users and roles. When you create a directory, you are automatically granted the READ and WRITE object privileges on the directory, and you can grant these privileges to other users and roles. You must have CREATE ANY DIRECTORY system privilege to create directories. GRANT for more information on granting object privilegesĮxternal_table_clause ::= of CREATE TABLE "Large Object (LOB) Datatypes" for more information on BFILE objects