how to get edit permissions for tables in hcp

[shivakishore]

Hi,

We have imported tables to HCP neo account and we were able to perform select queries on those tables but when we try to update the table we are getting an error message "insufficient privileges : not authorized".

can any one help me with the steps that i need to perform to get edit privileges??

[gowrisankar_m2 · Accepted solution]

Hello anchuri,

Insert; update; delete and drop to be granted via,

GRANT SELECT, INSERT, UPDATE, DELETE, DROP ON SCHEMA "XYZ" TO _SYS_REPO WITH GRANT OPTION;

BR, Gowrisankar