Grant SELECT privilege

[slayer]

Hi all,

Here is my case. I want to grant a SELECT privilege in a table with 150 columns. However, there are 2 or 3 fields in the table cannot be accessed by users throigh ODBC or JDBC. You see, revoke feature is only effective to REFERENCES and to UPDATES. Is there any way to make it worked?

 

[StefGay]

Hi,

to my mind the solution is to create a view (excluding some fields) on your table and allow users to "select" this view and not the main table.

Hope it helps.

Stéphane.