From: Gilberto Castillo <gilberto.castillo@etecsa.cu>
To: Diego Rivera Tavares de Araujo <diegoriverata@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [MASSMAIL] [ADMIN] Atribuição de permissão para todos objetos do banco de dados de uma única vez
Date: Tue, 11 Oct 2016 11:08:15 -0500 (GMT+5)
Message-ID: <46222.192.168.207.54.1476202095.squirrel@webmail.etecsa.cu> (raw)
In-Reply-To: <CAGajQxWUW2K1BLTUNBHP1oF_L+Bngg0iN6zxXVPJ2WiHvtdFGQ@mail.gmail.com>
References: <CAGajQxWUW2K1BLTUNBHP1oF_L+Bngg0iN6zxXVPJ2WiHvtdFGQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
> Bom dia,
>
> Estou com dificuldade para atribuir permissão para um usuario especifico
> para todos os objetos do banco de dados. Alguém poderia ajudar?
Usa este ejemplo mio:
SELECT current_user;
SET SESSION AUTHORIZATION postgres;
CREATE TABLE mitabla (id int, nombre text);
GRANT SELECT(nombre) ON mitabla TO usuario1;
GRANT UPDATE(nombre) ON mitabla TO usuario1;
REVOKE SELECT(nombre) ON mitabla FROM usuario1 restrict;
SET SESSION AUTHORIZATION usuario1;
SELECT * FROM mitabla;
--ERROR: permission denied for relation mitabla
SELECT nombre FROM mitabla;
--ERROR: permission denied for relation mitabla
INSERT INTO mitabla (id, nombre) VALUES (1,'Amaury');
--ERROR: permission denied for relation mitabla
UPDATE mitabla SET id = 2;
--ERROR: permission denied for relation mitabla
UPDATE mitabla SET nombre = 'Felipe';
--Query returned successfully: 1 row affected, 21 ms execution time.
Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gilberto.castillo@etecsa.cu, diegoriverata@gmail.com
Subject: Re: Re: [MASSMAIL] [ADMIN] Atribuição de permissão para todos objetos do banco de dados de uma única vez
In-Reply-To: <46222.192.168.207.54.1476202095.squirrel@webmail.etecsa.cu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox