DB2 Check Database Authority

by Online Tutorials Library July 14, 2014

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.

2. Activate the selected database “XYZ”.

3. Connect to the database named “XYZ”.

Check Database Authority

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”  

Example:

Check Database Authority

Next TopicDrop Database

DB2 Check Database Authority

Check Database Authority

Subarray with given sum

DBMS Join Dependency

You may also like