Re: asignación de roles ... mi experimento

Por si le interesa a alguien, aquí pongo un pequeño experimento para
descubrir 'que es que' en el mundo de los roles ... eso si, mejor en
monoespaciado.
*****************************************************************************
postgres=# \c test
Ahora está conectado a la base de datos «test».
test=# SELECT rolname, rolcanlogin FROM pg_authid;
rolname | rolcanlogin
---------------------+-------------
postgres | t
(1 filas)

test=# SELECT
test-# (SELECT rolname FROM pg_authid WHERE pg_authid.oid = fuente.roleid) AS
roleid,
test-# (SELECT rolname FROM pg_authid WHERE pg_authid.oid = fuente.member) AS
member,
test-# (SELECT rolname FROM pg_authid WHERE pg_authid.oid = fuente.grantor) AS
grantor
test-# FROM (SELECT * FROM pg_auth_members) AS fuente;
roleid | member | grantor
--------+--------+---------
(0 filas)

test=# CREATE ROLE rol1;
CREATE ROLE
test=# CREATE ROLE rol2;
CREATE ROLE
test=# CREATE ROLE rol3;
CREATE ROLE
test=# SELECT rolname, rolcanlogin FROM pg_authid;
rolname | rolcanlogin
---------------------+-------------
postgres | t
rol1 | f
rol2 | f
rol3 | f
(4 filas)

test=# CREATE USER usr1 IN ROLE rol1;
CREATE ROLE
test=# CREATE USER usr2;
CREATE ROLE
test=# SELECT
test-# (SELECT rolname FROM pg_authid WHERE pg_authid.oid = fuente.roleid) AS
roleid,
test-# (SELECT rolname FROM pg_authid WHERE pg_authid.oid = fuente.member) AS
member,
test-# (SELECT rolname FROM pg_authid WHERE pg_authid.oid = fuente.grantor) AS
grantor
test-# FROM (SELECT * FROM pg_auth_members) AS fuente;
roleid | member | grantor
--------+--------+----------
rol1 | usr1 | postgres
(1 fila)

test=# GRANT rol3 TO usr1;
GRANT ROLE
test=# GRANT rol3 TO usr2;
GRANT ROLE
test=# SELECT
test-# (SELECT rolname FROM pg_authid WHERE pg_authid.oid = fuente.roleid) AS
roleid,
test-# (SELECT rolname FROM pg_authid WHERE pg_authid.oid = fuente.member) AS
member,
test-# (SELECT rolname FROM pg_authid WHERE pg_authid.oid = fuente.grantor) AS
grantor
test-# FROM (SELECT * FROM pg_auth_members) AS fuente;
roleid | member | grantor
--------+--------+----------
rol1 | usr1 | postgres
rol3 | usr1 | postgres
rol3 | usr2 | postgres
(3 filas)

test=#
*****************************************************************************
Solo muy raramente pondré algo tan largo.
--
----o---( )---o----
Saludos de Victor Lopez Sabio
v(dot)lopez(dot)s(at)ono(dot)com
--------oooo--------