Sybase SQL anywhere 11 Grant/Revoke on column views

Question

My objective is to hide some column values to specific user or group on my views. I managed to give access to views, tables or table column with

GRANT SELECT [(MY COLUMN)] ON TABLE/VIEW TO MY_USER

for this query I have this error :

GRANT of column permission on view not allowed

But how can I block access to column in view ? (if I can't GRANT, it's also impossible with REVOKE I guess)

a simple example :

 CREATE VIEW AIRLINE_LIST 
        (ICAO_CODE,AIRLINE_NAME)
    AS SELECT 
        ARL_CODE,ARL_NAME
    FROM AIRLINE

so here I want that user TEST can see the AIRLINE_NAME data's but not the AIRLINE_CODE data's

Answer 1

You can't. From the SQL Anywhere 11 docs: "SELECT permissions on columns cannot be granted for views, only for tables".

Disclaimer: I work for SAP in SQL Anywhere engineering.