[ADMIN] grant question

[Tena Sakai]

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
tsa...@gallo.ucsf.edu