on 02-10-2012 11:15 AM
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
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
);
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.