Revoke owner's privilege on the table

[Maximiliano Araujo Pedatella]

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: [phone]
Fax : [phone]
mailto:***@administracao.go.gov.br


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Tom Lane]

Post by Maximiliano Araujo Pedatella
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?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Maximiliano Araujo Pedatella]

Jonh is really a superuser. Then, for this reason, cannot I revoke your
privilege in the referred table?

Maximiliano A. Pedatella
Fone: [phone]
Fax : [phone]
mailto:***@administracao.go.gov.br

-----Mensagem original-----
De: Tom Lane [mailto:***@sss.pgh.pa.us]
Enviada em: quinta-feira, 16 de setembro de 2004 20:07
Para: ***@administracao.go.gov.br
Cc: pgsql-***@postgresql.org
Assunto: Re: [ADMIN] Revoke owner's privilege on the table

Post by Maximiliano Araujo Pedatella
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?

regards, tom lane


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Peter Eisentraut]

Post by Maximiliano Araujo Pedatella
Jonh is really a superuser. Then, for this reason, cannot I revoke
your privilege in the referred table?

You can revoke all you want, but a superuser ignores all privilege
checks.