Check Database Authority
Use the following syntax to check the database authority which are granted to PUBLIC on the non-restrictive database:
1. First start your database.
db2start
2. Activate the selected database "XYZ".
db2 activate db XYZ
3. Connect to the database named "XYZ".
db2 connect to XYZ
Now verify the authorities of database:
Syntax:
db2 "select substr(authority,1,25) as authority, d_user, d_group,
d_public, role_user, role_group, role_public,d_role from table(
sysproc.auth_list_authorities_for_authid ('public','g'))as t
order by authority"
