on 02-17-2015 5:06 PM
Hello,
I have created a view with the following SQL Statement:
Set Schema "TEST_SCHEMA";
Drop view AN_LAST_PRICE;
Create view AN_LAST_PRICE AS ...
I can do the following:
Select * from AN_LAST_PRICE;
Now my colleage didn't have the permissions to select on my view. But he could do the following as well:
Set Schema "TEST_SCHEMA";
Drop view AN_LAST_PRICE2;
Create view AN_LAST_PRICE2 AS ...
With the same sub query I have used.
Now I wanted to grant him the select privilege to my view:
GRANT SELECT ON "TEST_SCHEMA"."AN_LAST_PRICE" to S000XXXXXX;
This results in:
Could not execute 'GRANT SELECT ON "TEST_SCHEMA"."AN_LAST_PRICE" to S000XXXXXX' in 1.234 seconds .
SAP DBTech JDBC: [258] (at 36): insufficient privilege: Not authorized to grant the privilege on the view: line 1 col 37 (at pos 36)
Do you know which privilege I miss?
Or how I can grant the privilege to select on my view to another user?
Thank you Wenjun,
I have checked your post but it did not help.
The problem is that the View I have created is based on a schema created by the SLT.
My colleage and I have the same permissions on the SLT schema. Then we both create a View based on the same tables, which we can both access via a Select Statement, we cannot make a Select on the views of each other.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.