>poderia ser assim?

>CREATE ROLE nome_do_cara LOGIN ENCRYPTED PASSWORD
>'md54eb9843b207239ce12440060f95ba40b'
>  NOINHERIT
>   VALID UNTIL 'infinity';
>GRANT grupo_usuarios TO nome_do_cara;


Mas asim so van heredar os set role, y nao os privilegios tais como 
SELECT,INSERT,UPDATE,DELETE,TRUNCATE,REFERENCES,TRIGGER, USAGE y otros

Saludo

Gustavo Garay
 

_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a