Subject Re: [firebird-support] Grant Select by Fields
Author Helen Borrie
At 07:15 PM 22/10/2004 -0200, you wrote:

>What is the SQL sintax for give the select grant in only two fields in one
>i was thinking about: "GRANT select ON TBL_USUARIOS (ID, ROTULO) TO PUBLIC"

You can only grant UPDATE and REFERENCES privileges at column level.

Use views to restrict what users can select. Grant the table SELECT rights
to the view, the grant SELECT rights on the view to the user or role.