Re: Column-level security

Have you tried this:

GRANT SELECT, UPDATE[, REFERENCES] (col1, col2,...col1) ON <schema>.<table_/view_name> TO <user_/role_name>/PUBLIC [WITH GRANT OPTION] ? The REFERENCES privilege is required only if a user needs to reference the column(s) in a FOREIGN KEY constraint. If you want to grant all three column privileges, you can use GRANT ALL [PRIVILEGES] ....rather than enumerating them by name.

I hope this helps.

Michael Serbanescu
Senior Consultant, MIACO Corporation Received on Sat Mar 22 1997 - 00:00:00 CET