cancel
Showing results for 
Search instead for 
Did you mean: 

Schema and table creation in HANA cloud

Former Member
0 Kudos

Hi ,

Please let me know how to create Schema and table in the HANA studion Cloud version.

Getting below error:

Could not execute 'create column table "P000284"."NASDAQ"( "EXCHANGE" VARCHAR (10) not null, "STOCK" VARCHAR (10) not ...'

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Regards,

Nagaraj

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member560074
Participant
0 Kudos

Try

/Connect to the HANA Studio

Make sure with which User You go to HANA Studio:

/Navigation

/Root node

/Properties

User Name: ???

/Click Catalog

/SQL Editor or /Icon Open SQL Edit for current session

/in the SQL editor (mind that You are the Schem_owner You are logged in )

Issues the following Statements:

CREATE USER HP PASSWORD INITIAL;

ALTER USER HP PASSWORD HPINVENT;

GRANT CONTENT_ADMIN TO HP;

GRANT MONITORING TO HP;

GRANT PUBLIC TO HP;

GRANT MODELING TO HP;

/* Test User*/

Connect HP password HPINVENT;

grant select on schema HP to SYSREPO with grant option;

CONENCT SYSTEM password <xxxxx>.

CREATE ROW TABLE "HP"."CHANNELS"

(

"CHANNEL_ID" INTEGER,

"CHANNEL_DESC" VARCHAR(20) ,

"CHANNEL_CLASS" VARCHAR( 20) ,

"CHANNEL_CLASS_ID" INTEGER,

"CHANNEL_TOTAL" VARCHAR(13),

"CHANNEL_TOTAL_ID" INTEGER

);

Former Member
0 Kudos

Hi Nagaraj,

If you are in Dev Center sandbox system, you don't need to create schema as system has already created a schema for you, the schema name is your user ID.

You can also try from Navigator Pane->Catalog-> Right click and select "Filter"->Input your user ID->OK, then you will find your own schema.

For table creation, this should be created on your above schema. Thus "create column table "AAAAAA"."BBBBBB"

AAAAAA should be your schema name;

BBBBBB should be your table name.

Regards,

Sophia

0 Kudos

Hi Nagaraj,

It looks like you might be trying to create a table in someone else's schema. Is P000284 your user id? If not, replace P000284 with your user id and it will create the table in your schema, which you have full privileges on.

Cheers,

Jody

Former Member
0 Kudos

Hi ,

I am not able to create schema itself , please let me know on the same.

Regards,

Nagaraj

Former Member
0 Kudos

How to create a schema under catalog? with my ID.

I dnt see any Schema with my Id under catalog

0 Kudos

Hi Nagaraj,

I'm assuming your working in the Dev Center sandbox system. In this case, there is a schema already created with your user ID, and you have full priviliges to create/edit tables in this schema.

If you are unable to see your schema in the studio, try one of the following:

- Window -> Preferences -> Administration Console -> Catalog and check the "Fetch all database catalog objects", or

- Right-click the Catalog node in the Navigator view and set a filter on your userid

Please see Juergenu2019s reply on this thread for more info: http://forums.sdn.sap.com/thread.jspa?messageID=10864075#10864075

Cheers,

Jody