/scripts/ahub.form.attachments.js
0

SQLScript REVOKE command issue

Jan 12, 2017 at 08:45 AM

17

avatar image

Hi,

I executed this Revoke command for one of my table.

REVOKE SELECT ON "CLF01"."CAR" from _sys_repo;

i was expecting that after this i will not be able to execute select query on this table but i can see records with no issue.

could anybody please help what im doing wrong with this Revoke.

Thank you

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

1 Answer

Best Answer
Florian Pfeffer
Jan 27, 2017 at 02:14 PM
1

With that statement you revoke the select privileges for the specific table from user _SYS_REPO. That means that this user cannot read data anymore. For instance if you have a defined a calculation view getting data from that table, you get an authorization error, cause the calc. view belongs to and is executed by _SYS_REPO which has not rights anymore.

If you do a select with another user (which I assume you did e.g. in the console) and the user has privileges the selection works. So the question is: What user you used and what privileges he has?

Share
10 |10000 characters needed characters left characters exceeded
Skip to Content