On 12/05/14 08:33, David G Johnston wrote:
I was thinking of using privileges to control access, for user 'fred':
REVOKE ALL ON my_role FROM fred;
GRANT SELECT ON my_role TO fred; That's the guts of it, you will obviously need to check other tables and their appropriate privileges.
Note that both commands have the option 'ALL TABLES IN SCHEMA
schema_name'.
Cheers,
Gavin
P.S. You forgot to include my name (and date/time) from the bit you quoted from me!