Skip to Content
-1

user is not authorized (2950) while creating calculation view

Hi,

I am trying to create a calculation view but I am ending up with error "

user is not authorized (2950)". I think i hae a NON System user id: 'HANA'.

I checked the roles and privileges for my user' HANA' and SYS_REPO..etc

Am I still missing anything.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 25, 2016 at 05:19 AM

    Execute the below statement in SQL console and activate your view

    GRANT SELECT ON SCHEMA SCHEMA_ABC TO _SYS_REPO WITH GRANT OPTION

    Note : At SCHEMA_ABC give your schema name

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 10:16 PM

    Hi,

    I happened to use Schema's from different Packages and hence used the above GRANT SELECT statement.

    Add comment
    10|10000 characters needed characters exceeded