Re: [GENERAL] Determining what a user can access

2003-12-10 Thread Joe Conway
Martijn van Oosterhout wrote: Thanks, I've never seen that page before. I guess it must be new. There may be more elegant ways to do this, and I'm sure this is incomplete/could be improved upon, but just for grins: --- create type us

Re: [GENERAL] Determining what a user can access

2003-12-09 Thread Martijn van Oosterhout
Thanks, I've never seen that page before. I guess it must be new. Thanks. On Wed, Dec 10, 2003 at 07:37:16AM +0100, Peter Eisentraut wrote: > Martijn van Oosterhout wrote: > > I was just trying to find a query what would determine, given a > > username, what tables they can see and what permissio

Re: [GENERAL] Determining what a user can access

2003-12-09 Thread Peter Eisentraut
Martijn van Oosterhout wrote: > I was just trying to find a query what would determine, given a > username, what tables they can see and what permissions they have on > those tables. Obviously this would only work for superusers, but does > anyone have any ideas? http://www.postgresql.org/docs/cur

[GENERAL] Determining what a user can access

2003-12-09 Thread Martijn van Oosterhout
I was just trying to find a query what would determine, given a username, what tables they can see and what permissions they have on those tables. Obviously this would only work for superusers, but does anyone have any ideas? A while ago someone tried using the like operator, would that be the bes