[jira] [Resolved] (HAWQ-771) Table and function can not be found by non-superuser in specified schema

["Ming LI (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ming LI resolved HAWQ-771.
--------------------------
    Resolution: Invalid

By default, users cannot access any objects in schemas they do not own. To allow that, the owner of the schema must grant the USAGE privilege on the schema. 

So please run below SQL before select that table in testrole:
grant usage on schema testschema to testrole;

> Table and function can not be found by non-superuser in specified schema
> ------------------------------------------------------------------------
>
>                 Key: HAWQ-771
>                 URL: https://issues.apache.org/jira/browse/HAWQ-771
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Catalog
>    Affects Versions: 2.0.0.0-incubating
>            Reporter: Ruilong Huo
>            Assignee: Ruilong Huo
>             Fix For: backlog
>
>         Attachments: function.out.bug, function.out.expected, function.sql, table.out.bug, table.out.expected, table.sql
>
>
> With non-superuser, table and function can not be found in specified schema. While:
> 1) they can be found in default schema, i.e., "$user", public
> 2) they can be found by superuser.
> This issue occurs in hawq 2.0 and postgres 9.x. See attached sql file for reproduction steps and out file for expected/actual error.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)