SQLScript REVOKE command issue

Former Member — Thu, 12 Jan 2017 08:45:25 GMT

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

Re: SQLScript REVOKE command issue

pfefferf — Fri, 27 Jan 2017 14:14:58 GMT

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?

topic Re: SQLScript REVOKE command issue in Application Development and Automation Discussions

SQLScript REVOKE command issue

Re: SQLScript REVOKE command issue