Обсуждение: 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:maxp@administracao.go.gov.br

"Maximiliano Araujo Pedatella" <maxp@administracao.go.gov.br> 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?

            regards, tom lane

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

Maximiliano A. Pedatella
Fone: +55 (62) 201-6571
Fax  : +55 (62) 201-6573
mailto:maxp@administracao.go.gov.br

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


"Maximiliano Araujo Pedatella" <maxp@administracao.go.gov.br> 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?

            regards, tom lane

Maximiliano Araujo Pedatella wrote:
> 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.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/