Solved: SQLScript REVOKE command issue

Former Member · ‎2017 Jan 12

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

pfefferf · ‎2017 Jan 27

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?

pfefferf · ‎2017 Jan 27

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?