2.3.9 Assign Grants to Studio Schema to Access the Filestore Directories

Note:

This section is applicable only for Graph use case.

Grant the following permissions to Studio Schema to access filestore directories.

CREATE OR REPLACE DIRECTORY fs_list_logs_dir AS '<Location of the Created
Directory>/file_store/fs_list/logs/';
GRANT READ, WRITE ON DIRECTORY fs_list_logs_dir TO $STUDIO_DB_USERNAME;
CREATE OR REPLACE DIRECTORY fs_list_script_dir AS '< Location of the Created
Directory >/file_store/fs_list/script/';
GRANT READ, EXECUTE ON DIRECTORY fs_list_script_dir TO $STUDIO_DB_USERNAME;
CREATE OR REPLACE DIRECTORY fs_list_control_dir AS '<Location of the Created
Directory >/file_store/fs_list/control/';
GRANT READ ON DIRECTORY fs_list_control_dir TO $STUDIO_DB_USERNAME;
CREATE OR REPLACE DIRECTORY external_tables_dir AS '<Location of the Created
Directory >/file_store/fs_list/fccm-data/';
GRANT READ ON DIRECTORY external_tables_dir TO $STUDIO_DB_USERNAME;