Re: Why grantor is owner in this case?

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
applicationjust 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
beingdiscussed 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
dois wrap your GRANT statements in functions that log what was done and by whom to a table and then consult that log
tablewhen you need that info. 

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