GRANT Directory Permission Syntax
GRANT Create Directory Permission Syntax
Examples
To grant read access on a directory named kdata to the kuser user:GRANT Directory Read Permission Example
GRANT Directory Write Permission Example
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
GRANT <READ | WRITE> [PRIVILEGES]
ON <ALL DIRECTORIES | DIRECTORY < <directory name> | * >>
TO <user name | role name> [WITH GRANT OPTION]
GRANT CREATE DIRECTORY [PRIVILEGES]
TO <user name | role name> [WITH GRANT OPTION]
| Permission | Description |
|---|---|
READ | List, download, or load data from files within the given directory. |
WRITE | Upload files to or delete files from the given directory (includes READ access). |
<directory reference> | The name of the directory to which access is being granted, or * for all directorys. The following forms are valid: <directory name>: The specified directory *: All directorys, both existing and future |
CREATE DIRECTORY | Create directory permission |
WITH GRANT OPTION | Grant this permission with a grant option to grant it to others. |
GRANT READ ON DIRECTORY 'kdata' TO kuser
GRANT WRITE ON DIRECTORY 'kdata' TO kuser