[jira] [Updated] (HAWQ-1257) If user doesn't have privileges on certain objects, need return user which specific table he doesn't have right.

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

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

Lili Ma updated HAWQ-1257:
--------------------------
    Assignee: Hongxu Ma  (was: Ed Espino)

> If user doesn't have privileges on certain objects, need return user which specific table he doesn't have right. 
> -----------------------------------------------------------------------------------------------------------------
>
>                 Key: HAWQ-1257
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1257
>             Project: Apache HAWQ
>          Issue Type: Sub-task
>          Components: Security
>            Reporter: Lili Ma
>            Assignee: Hongxu Ma
>             Fix For: 2.2.0.0-incubating
>
>
> If user doesn't have privileges on certain objects, need return user all the objects he doesn't have right, to avoid the user modify one privilege, and then find another privilege constraint, and then another... which may bother the user a lot.
> For example:
> user didn't have the rights of t1 and t2.
> {code}
> postgres=> select * from test_sa.t1 left join test_sa.t2 on test_sa.t1.i=test_sa.t2.i;
> ERROR:  permission denied for relation t1
> {code}
> We wish to prompt user didn't have the rights of t2 also.



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