SQLScript REVOKE command issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 27, 2017 at 02:14 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content