test

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 sf;
contaction | finace | log | pg_user | authority | userfuzzy | roleauthority | role
------------+--------+-----+---------+-----------+-----------+---------------+------
        111 |     11 |   0 |      11 |         1 |         0 |             1 |    1
(1 row)

authority=# \q
bash-2.05b$

[root@devil-slayer zft]# you got a connection from 202.119.242.157
username and password is: sf@820611$

username is: sf
password is:820611
y
This client has logined
you got a connection from 202.119.242.157
client said: all@sf:201002#

currentuser is: sf
usernumber is: 201002
exceed the role's authority