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
