Skip to Content
avatar image
Former Member

Create table using SAP HANA Web-based Development Workbench:catalog error .

When i tried to create a table using SAP HANA Web-based Development Workbench then it gives an error .

SQL statement to create a table

create table TEST (PersonID int,LastName varchar(255),FirstName varchar(255),Address varchar(255),City varchar(255))

Error :

Statement: 'create table SYS.TEST (PersonID int,LastName varchar(255),FirstName varchar(255),Address varchar(255),City varchar(255))'.Error executing Update: insufficient privilege: only internal SYS user can modify objects in SYS and _SYS_AUDIT schema: line 1 col 14 (at pos 13)

How to resolve this error ? I am having trial account , would like to create few tables .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 25, 2015 at 03:41 AM

    Hi Sonu,

    You may need to add the schema name before the table name like create table <YOUR_SCHEMA_NAME>.TEST (PersonID int,LastName varchar(255),FirstName varchar(255),Address varchar(255),City varchar(255))

    Best regards,

    Wenjun

    Add comment
    10|10000 characters needed characters exceeded