Re: getTablePrivileges empty if table owned by group role

From: Jonas Sundman <jonas(dot)sundman(at)thl(dot)fi>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: getTablePrivileges empty if table owned by group role
Date: 2011-08-23 12:30:07
Message-ID: 4E539D4F.6090803@thl.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi all,

after some digging and further reading in the todo list I learned that acl
parsing is known to be uncompatible with versions after 7.3.

I decided to have a look into the code and turned up with a working version of
the acl parsing, which I would like to share.

To summarize whats in there
- use rolename instead of username (which corrects the problem which my
original message refers to)
- handle the grantor part of the acl
- handle the grantable attribute
- use attacl for column permissions.

The patch is against the development version (build 900). I have tested this
against 8.4.4.

Best regards,

Jonas Sundman

Attachment Content-Type Size
AbstractJdbc2DatabaseMetaData.java.patch text/x-patch 6.2 KB

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2011-08-23 17:19:51 Re: getTablePrivileges empty if table owned by group role
Previous Message JavaNoobie 2011-08-23 10:07:37 Re: Update+ Prepared Statement Error.