m Lane for the help
Louis.
-Original Message-
From: Martijn van Oosterhout [mailto:klep...@svana.org]
Sent: Friday, June 05, 2009 1:18 PM
To: Louis Lam
Cc: Tom Lane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] catalog view use to find DATABASE,
LANGUAGE,TABLESPACE, SCHEMA, SEQUENCE
On Wed, Jun 03, 2009 at 01:46:00PM -0500, Louis Lam wrote:
> So if I need to find out what table, view and function are granted to
> user or role. I should be force to use pg_class and pg_proc? Unless I
> can have superuser access?
Use \dv+ on the information_schema view you want and copy the qu
2:15 PM
To: Louis Lam
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] catalog view use to find DATABASE, LANGUAGE,
TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role
"Louis Lam" writes:
> Since you know this are well. Do you know if there is some kind of
>
"Louis Lam" writes:
> Since you know this are well. Do you know if there is some kind of
> records filtering use by PostgreSQL when selecting system objects? For
> example, I run this query by PostgreSQL user.
> select count(*) from information_schema.table_privileges;
The information_schema
making that user a superuser?
Thanks again,
Louis Lam.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, June 02, 2009 6:43 PM
To: Louis Lam
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] catalog view use to find DATABASE, LANGUAGE,
TABLESPACE
"Louis Lam" writes:
> Thank you very much for the quick response. That was very helpful. I
> was able to find the privilege on pg_language, pg_database and
> pg_tablespace. I am looking for privileges granted to SCHEMA and
> SEQUENCE. Do you by any change know what view or table I can queries
d DATABASE, LANGUAGE,
TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role
"Louis Lam" writes:
> In PostgreSQL, there are some grant privileges like grant on SEQUENCE,
> DATABASE, LANGUAGE, SCHEMA and DATABASE. I grant and revoke these
> privleges on my PostgreSQL on Wi
"Louis Lam" writes:
> In PostgreSQL, there are some grant privileges like grant on SEQUENCE,
> DATABASE, LANGUAGE, SCHEMA and DATABASE. I grant and revoke these
> privleges on my PostgreSQL on Windows and Linux OS. But once it is
> granted, how do I find out what user and role are granted with t
Hi,
In PostgreSQL, there are some grant privileges like grant on SEQUENCE,
DATABASE, LANGUAGE, SCHEMA and DATABASE. I grant and revoke these
privleges on my PostgreSQL on Windows and Linux OS. But once it is
granted, how do I find out what user and role are granted with these
privileges?
