[
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)
