I am doing bulk load using COPY statement. I created a storage location called reject_data for the rejected data and granted privilege to the user. Now I don't want that storage location anymore. So, I wanted to revoke privilege using REVOKE ALL ON LOCATION 'path' FROM user;. I am getting an error ROLLBACK 5365: User available location ["storage_location"] does not exist on node ["nodename"]. I queried the storage_locations view in v_catalog to confirm that it's there. I tried DROP_LOCATION, that gives an error too - ERROR 3135: drop_location for DATA locations is not supported. I have retired the location successfully with select RETIRE_LOCATION from the same path and same node.
Can someone tell me why REVOKE and DROP_LOCATION failed and what can be done to not get this error anymore.
Thanks for your help.
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.