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?
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
Support, Scalability, Reliability
866.518.9273 x 260
In response to
pgsql-general by date
|Next:||From: Adrian Klaver||Date: 2009-12-29 01:34:33|
|Subject: Re: cross-database time extract?|
|Previous:||From: Ivano Luberti||Date: 2009-12-28 22:17:16|
|Subject: Re: Java Postgres drivers.|