I must not understand the permissions system

From: David Rysdam <drysdam(at)ll(dot)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: I must not understand the permissions system
Date: 2005-11-10 14:31:07
Message-ID: 437359AB.6090800@ll.mit.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From both User A and User B, this query returns rows:

select * from pg_trigger where tgname = '<name>'

but User A gets 2 rows (because I have the same trigger name on two
different tables) while User B only sees one of them. Is it permissions
on pg_trigger or on the original table (or some other thing) that is
preventing B from seeing that row?

Browse pgsql-general by date

  From Date Subject
Next Message Helge Elvik 2005-11-10 14:33:13 Compiling libpq on Windows
Previous Message A. Kretschmer 2005-11-10 14:18:04 Re: time zone - timestamp