ERROR 4368: Permission denied for storage location [<location name>]I am using Linux and the file is located in a directory that has read access to all users (733).
Error reading CSV data file (Error 4368)
I am trying to load data into a newly created table. I get the following error:
I tried loading using the dba account (dbadmin) and the loading is happening fine. So the question is why is that a non-dba user was unable to read the data file? Is it really a data file reading problem or privileges issue with the user or the schema?
+2Hi,
The issue is probably because of file system permission.
If you use the copy command the issue is that a user do not have access to the file system to read the file. A solution is to add a storage_location as user type where you can put your files there.
Hope this answer your question,
Eugenia
The issue is probably because of file system permission.
If you use the copy command the issue is that a user do not have access to the file system to read the file. A solution is to add a storage_location as user type where you can put your files there.
Hope this answer your question,
Eugenia
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
