test_inh.sh

application/x-sh

Download

X=1
cat <<END
CREATE ROLE init_1_noinherit NOINHERIT;
CREATE ROLE init_2_inherit INHERIT;
CREATE ROLE init_3_noinherit NOINHERIT;
CREATE ROLE init_4_inherit INHERIT;
END
for ROLE1 in init_1_noinherit init_2_inherit
do	for ROLE2 in init_3_noinherit init_4_inherit
	do 	for INH in INHERIT NOINHERIT
		do	echo "CREATE ROLE user_${X}_${INH} ROLE $ROLE1 IN ROLE $ROLE2 $INH;"
			X=$((X + 1))
		done
	done
done

cat <<END
SELECT rolname, roleid::regrole AS "Is member of role", inherit_option
FROM  pg_roles, pg_auth_members
WHERE member = pg_roles.oid AND
      rolname NOT LIKE 'pg_%'
ORDER BY 1, 2;
END