Обсуждение: 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/