Skip to Content
0
Mar 27, 2015 at 07:58 AM

How to import data to create table in schema?

35 Views

Dear friends,

I try to import my CSV file to create table in schema, I did create successfully in schema DEV_******, but when I active it and open data view, it have the error message: Insufficient privileges - not authorized.

I had try this two statement in SQL console but still not working.

GRANT SELECT ON SCHEMA DEV_6FEWKFQWETNALK3447771VQO5 TO _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SCHEMA DEV_6FEWKFQWETNALK3447771VQO5 TO p1680829412;

Then I remember this:

The database schema that is prefixed with NEO_ is the development schema. You should store all database artifacts connected to application development like tables, stored procedures, and so on in this schema. The database schema that is prefixed with DEV_ is the private schema of the developer user. You should not create database artifacts that are to be used in your cloud applications in this private schema.


So I try to import data to create table in schema NEW_************, but it have another error:

Insufficient privileges - User DEV_6FEWKFQWETNALK3447771VQO5 does not have CREATE ANY privilege(s) on the selected schema.


So many privileges problem, how to solve this kind of problem ?