Skip to Content
-1

user is not authorized (2950) while creating calculation view

Oct 25, 2016 at 04:28 AM

2.8k

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Gopinath Kolli Oct 25, 2016 at 05:19 AM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi,

I am using Schema's from different Packages and hence used the above GRANT SELECT statement.

0

You saved my day , pal !

1

you are most welcome.

Only Beers accepted in return :-P

0
Ricky Shaw Oct 25, 2016 at 10:16 PM
0

Hi,

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

Share
10 |10000 characters needed characters left characters exceeded