Message-ID: <46222.192.168.207.54.1476202095.squirrel@webmail.etecsa.cu>
In-Reply-To: 
     <CAGajQxWUW2K1BLTUNBHP1oF_L+Bngg0iN6zxXVPJ2WiHvtdFGQ@mail.gmail.com>
References: 
    <CAGajQxWUW2K1BLTUNBHP1oF_L+Bngg0iN6zxXVPJ2WiHvtdFGQ@mail.gmail.com>
Date: Tue, 11 Oct 2016 11:08:15 -0500 (GMT+5)
Subject: 
 =?utf-8?B?UmU6IFtNQVNTTUFJTF0gW0FETUlOXSBBdHJpYnVpw6fDo28gZGUgcGVybWlz?=
 =?utf-8?B?c8OjbyBwYXJhIHRvZG9zIG9iamV0b3MgZG8gYmFuY28gZGUgZGFkb3MgZGUg?=
 =?utf-8?B?dW1hIMO6bmljYSB2ZXo=?=
From: "Gilberto Castillo" <gilberto.castillo@etecsa.cu>
To: "Diego Rivera Tavares de Araujo" <diegoriverata@gmail.com>
Cc: pgsql-admin@postgresql.org
Reply-To: gilberto.castillo@etecsa.cu
User-Agent: SquirrelMail/1.4.8-5.el5_4.10
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit
Importance: Normal
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


> 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