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