Details
-
Sub-task
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
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.
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
We wish to prompt user didn't have the rights of t2 also.
