Jason Hihn <jhihn@paytimepayroll.com> writes:
> Ok, so I have a question If I have 2 databases, a and b, and they both have
> a table, c, how do I grant permissions only to table a.t and not both tables
> in both databases at the same time? The intituve answer is not correct -
> that 'ON a.t ...' does not work.
Perhaps you'd better show us exactly what you tried, because the above
doesn't have any connection to my view of reality. I don't see any way
that a single grant command could affect two databases.
regards, tom lane