Ebin Jozer, July 20, 2017 - 4:04 am UTC
Ebin Jozer, August 09, 2017 - 12:32 pm UTC
Hi chris,
thanks for the elaborated information.
as per security i dont want to provide "create any directory" privilege, will the external table still be created?
the external table has been created via stored procedure, if i remove "create any table" it is not allowing to create the external table, showing "insufficient privilege".
Please advise.
August 09, 2017 - 12:43 pm UTC
You need to have access to a directory object pointing to the file location to make an external table. So either you need someone else to create it for you and have read & write privs on it or create it yourself (which requires "create any directory").
You need "create table" or "create any table" to make tables. You should stick with plain "create table" the vast majority of the time.
But... why are you building the table via a stored procedure?!