roleauthority

bash-2.05b$ psql roleauthority
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

roleauthority=# select * from dba;
contaction | finace | log | pg_user | authority | userfuzzy | roleauthority | role
------------+--------+-----+---------+-----------+-----------+---------------+------
          0 |      0 | 111 |     111 |       111 |       111 |           111 |  111
(1 row)

roleauthority=# select * from staff;
contaction | finace | log | pg_user | authority | userfuzzy | roleauthority | role
------------+--------+-----+---------+-----------+-----------+---------------+------
        111 |      0 |   0 |      11 |         1 |         0 |             1 |    1
(1 row)

roleauthority=# select * from finace;
contaction | finace | log | pg_user | authority | userfuzzy | roleauthority | role
------------+--------+-----+---------+-----------+-----------+---------------+------
          0 |    111 |   0 |      11 |         1 |         0 |             1 |    1
(1 row)

roleauthority=#



bash-2.05b$ psql authority
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

authority=# select * from zft;
contaction | finace | log | pg_user | authority | userfuzzy | role | roleauthority
------------+--------+-----+---------+-----------+-----------+------+---------------
        111 |    111 |   0 |      11 |         1 |         0 |    1 |             1
(1 row)

authority=#