Skip site navigation (1) Skip section navigation (2)

Re: Why grantor is owner in this case?

From: Erik Jones <ejones(at)engineyard(dot)com>
To: donniehan <donniehan(at)126(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why grantor is owner in this case?
Date: 2009-12-29 00:46:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Dec 27, 2009, at 6:59 PM, donniehan wrote:

> Hi Tom,
> Thanks for your information. One more question, if i wanna get the accurate information about grantor(Sometimes the application just needs the information), what can i do?
> Apparently i cannot get from the acls, so where can i get the info?
> -Dongni

First, please, trim posts and don't top post, it makes it confusing for others to follow along with what's currently being discussed in a thread when you don't do either.

As to how you can determine who *actually* made a particular grant, there isn't any built-in way.  What you'd need to do is wrap your GRANT statements in functions that log what was done and by whom to a table and then consult that log table when you need that info.

Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k

In response to

pgsql-general by date

Next:From: Adrian KlaverDate: 2009-12-29 01:34:33
Subject: Re: cross-database time extract?
Previous:From: Ivano LubertiDate: 2009-12-28 22:17:16
Subject: Re: Java Postgres drivers.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group