Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Major |
| Complexity | Unknown |
| Component | App - Visual Editing |
| Version | 13.0 |
While working on issue #8119, noticed that I was not able to extract Greenplum object permissions using visual editors (such as Table, User, Role, etc.). The query failed and a 'permission denied for relation pg_authid' exception (shown below) is thrown; I logged onto Greenplum server as 'dba'. Have we made any changes on the Greenplum server running on 10.168.2.181 and/or the 'dba' account there recently?
<2012-12-26 21:16:00,421> ERROR [Thread-66] <com.aquafold.aquacore.security.extract.ExtractObjectPermissionGreenplum>
org.postgresql.util.PSQLException: ERROR: permission denied for relation pg_authid
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
at com.aquafold.aquacore.scripts.WrappedStatement.executeQuery(WrappedStatement.java:159)
at com.aquafold.aquacore.scripts.ClusterDBStatement.executeQuery(ClusterDBStatement.java:265)
at com.aquafold.aquacore.security.extract.ExtractObjectPermissionGreenplum.getObjectPermissions(ExtractObjectPermissionGreenplum.java:310)
at com.aquafold.aquacore.security.extract.ExtractObjectPermission.getObjectPermissions(ExtractObjectPermission.java:2789)
at com.aquafold.aquacore.security.extract.ExtractObjectPermission.getObjectPermissionsByGrantee(ExtractObjectPermission.java:28)
at com.aquafold.datastudio.visualedit.security.greenplum.GreenplumObjectPermissionDialog.getObjectPermissions(GreenplumObjectPermissionDialog.java:151)
at com.aquafold.datastudio.visualedit.security.ObjectPermissionDialog$UpdateThread.run(ObjectPermissionDialog.java:823)
To reproduce the problem, simply try one of the following test cases and a few exceptions will be logged:
(1) alter an existing table and then click the 'Permissions' tab, or
(2) alter an existing user and then click the 'Object Permissions' button.
Yes, Tariq made some changes to the dba user which caused problems.
Yes, Tariq made some changes to the dba user which caused problems.
Ivan has re-installed the greenplum database and you wont get this error anymore
Ivan has re-installed the greenplum database and you wont get this error anymore
Issue #8120 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 13.0-alpha-21 |
| No time estimate |
To reproduce the problem, simply try one of the following test cases and a few exceptions will be logged:
(1) alter an existing table and then click the 'Permissions' tab, or
(2) alter an existing user and then click the 'Object Permissions' button.