Hey all!!

Should I prefer using views in most cases or avoid it?

Once Helen told me that I should use Views to limit the Select in tables.
I was trying to execute sth like "GRANT SELECT ON TBL_CUSTOMER (ID, LABEL,
etc) TO SMACE".
It wasn't working, but If execute the sql this way:

INSERT INTO RDB$USER_PRIVILEGES
(RDB$USER, RDB$GRANTOR, RDB$PRIVILEGE, RDB$GRANT_OPTION, RDB$RELATION_NAME,
RDB$FIELD_NAME, RDB$USER_TYPE, RDB$OBJECT_TYPE )

VALUES ('SMACE', 'SYSDBA', 'S', NULL, 'TBL_CUSTOMER', 'ID', 1, 0);
VALUES ('SMACE', 'SYSDBA', 'S', NULL, 'TBL_CUSTOMER', 'ROTULO', 1, 0);

It works but only SYSDBA can execute the script above.
What is the firebird sintax for granting table's fields?
(Once firebird understands granting select table's fields to users like SQL
above)
Or Do I must use Views?

Regards,

Sérgio Marcelo
smace@...
Ps.: Sorry about my basic English, I had run away from school :-(