[jira] [Commented] (HAWQ-1365) Print out detailed schema information for tables which the user doesn't have privileges

["Hongxu Ma (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HAWQ-1365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15887476#comment-15887476 ] 

Hongxu Ma commented on HAWQ-1365:
---------------------------------

new ERROR info:

{code}
postgres=> select * from public.t, test_sa.t;
ERROR:  permission denied for relation(s): public.t, test_sa.t

postgres=> select * from t;
ERROR:  permission denied for relation(s): public.t
postgres=> select * from test_sa.t;
ERROR:  permission denied for relation(s): test_sa.t

postgres=> select * from rank;
ERROR:  permission denied for relation(s): public."rank_1_prt_extra" (partition of relation "rank"), public."rank_1_prt_2" (partition of relation "rank"), public."rank_1_prt_3" (partition of relation "rank"), public."rank_1_prt_4" (partition of relation "rank"), public."rank_1_prt_5" (partition of relation "rank"), public."rank_1_prt_6" (partition of relation "rank"), public."rank_1_prt_7" (partition of relation "rank"), public."rank_1_prt_8" (partition of relation "rank”)

postgres=> select * from rank_1_prt_2;
ERROR:  permission denied for relation(s): public."rank_1_prt_2" (partition of relation "rank”)
{code}

> Print out detailed schema information for tables which the user doesn't have privileges
> ---------------------------------------------------------------------------------------
>
>                 Key: HAWQ-1365
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1365
>             Project: Apache HAWQ
>          Issue Type: Improvement
>            Reporter: Hongxu Ma
>            Assignee: Hongxu Ma
>             Fix For: 2.2.0.0-incubating
>
>
> Business Value:
> Current output information for the table name which user doesn't have privileges doesn't include schema output.  We should print out the schema information out, otherwise it's difficult for users to identify the identified table.
> {code}
> postgres=# select * from public.a, s1.a;
> ERROR:  permission denied for relation(s): a, a
> {code}
> Should print out the schema information for the table.
> {code}
> postgres=# select * from public.a, s1.a;
> ERROR:  permission denied for relation(s): public.a, s1.a
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)