Hi Everybody,
I want to issue a command:
grant select on schema_Z to user_a;
so that the user_a can look at all tables in schema_Z.
Sadly, what I get is:
ERROR: relation "schema_Z" does not exist
I tried:
grant select on schema_Z.* to user_a;
and response was:
ERROR: syntax error at or near "to"
LINE 1: grant select on schema_Z.* to user_a;
Please tell me what I command I should issue instead
to get what I want done?
Thank you in advance.
Regards,
Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu