Skip to Content
author's profile photo
Former Member

Insufficient privilages to create schema.

Hi Everyone,

I am using Hana Cloud Platform. and I would like to create schema which I am not able to create.

Error is as fallows:

Could not execute 'CREATE SCHEMA STS'

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

I would like to know which objects to be added to user _SYS_REPO to get access to create schema, tables, views, attribute views, and rest of the DB related actions on HCP.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Mar 04, 2015 at 12:03 PM

    Hi,

    If you use HCP trial, you won't be able to create schema as DEV_XXX as you are not granted this privilege.

    Best regards,

    Wenjun

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      We don't have access to created new schema as default schema is created by activation of HANA account and suppose to use the schema created with this account DEV_XXXXX

  • author's profile photo
    Former Member
    Mar 04, 2015 at 11:44 AM

    Hi Satish,

    Can you please check in SECURITY tab if you have access to create schema inside in 'System Privileges' for your userID?

    Security--->Uses-->System Privileges-->Create Schema

    BR

    Sumeet

    Add comment
    10|10000 characters needed characters exceeded