Permissions
You can select from tables in schemas owned by the effective user, group, and role of the session. To select rows from tables in schemas owned by other users, groups, and roles:
• The schema parameter must be specified.
• The effective user, group, or role of the session must have SELECT permission.