[jira] [Created] (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>]

Lili Ma created HAWQ-1257:
-----------------------------

             Summary: 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: Ed Espino
             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)