Re: [ADMIN] Revoke owner's privilege on the table

"Maximiliano Araujo Pedatella" <[EMAIL PROTECTED]> writes: > Does anybody know as I do to revoke the privilege of the user owner of a > certain table, because the command, for example, "REVOKE ALL ON TABLE test > FROM jonh;" is not working? Perhaps jonh is a superuser?

[ADMIN] Revoke owner's privilege on the table

Hello, Does anybody know as I do to revoke the privilege of the user owner of a certain table, because the command, for example, "REVOKE ALL ON TABLE test FROM jonh;" is not working? Respectfully, Maximiliano A. Pedatella Fone: +55 (62) 201-6571 Fax : +55 (62) 201-6573 mailto:[EMAIL PROT

Re: [ADMIN] VACUUM FULL achieves nothing / Postgres 7.3.2 + RedHat 7.3

R. Willmington wrote: > Gaetano Mendola <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > > >>Are you sure you dont have connection in status: "idle in transaction"? >>Check with: >> >>ps -eafwww | grep post >> >> >>Gaetano > > > Hello Gaetano, > > Thank you for the reply. > I have

[ADMIN] windows docs?

Title: Message When starting the Windows psql client I get a warning that the "console codepage (437) differs from the windows codepage (1252)" and to see installation on Windows for details.  I am having trouble finding this documentation.   I've also been looking for the "Windows FAQ" whi

[ADMIN] tgtype

Hi,   Though I can interpret the meaning of pg_trigger.tgtype, I am wondering if any PG table can be used to join with pg_trigger to get the meaning like: tgtype=5, is row level after insert trigger   Also any doc discussing this?   Thanks,  

[ADMIN] Clone a user's permissions to a group

Can I run something by y'all to see if I'm on the right track, or have fallen off my rocker? ... Postgresql 7.4 ... Essentially I want to convert a user to a group. I want this new group to have the same privileges to the same objects that the original user had. I can then remove privileges from

Re: [ADMIN] VACUUM FULL achieves nothing / Postgres 7.3.2 + RedHat

On 15 Sep 2004, R. Willmington wrote: > In order to reproduce the problem, i copied the above database to my > staging system (same linux, same postgres), and ran a vacuum full > analyze. It finished after 33 minutes. After the vacuum full the > deletion from the 20.000 records table succeeded with

[ADMIN] securing pg_catalog

I want to create a user that has read only access to the tables in a schema. I was able to configure that fine, but that user can see all of the information in the pg_catalog schema. I do not want this user to be able to see anything other than the one schema, I tried revoking rights to schema pg

[ADMIN] connections manager

Hi, I would like to know if there is a script or software that can bring me information about the connections on my PostgreSQL databases. Thanks, -- - - - - - - - - - - - - - - - - - - - - - - Lic. Guillermo J. González Rodas Ms. Ing. del Software [EMAIL PROTECTED] CyBIra Consulting Lapacho Nro.