Re: Modifying pg_shadow?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jason Hihn <jhihn(at)paytimepayroll(dot)com>
Cc: Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Modifying pg_shadow?
Date: 2003-09-09 15:30:18
Message-ID: 23971.1063121418@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Jason Hihn <jhihn(at)paytimepayroll(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Fromme 2003-09-09 15:55:06 Re: Modifying pg_shadow?
Previous Message Tom Lane 2003-09-09 15:27:47 Re: Modifying pg_shadow?