Database Rights Management

Format Query DB permissions
DB2 "SELECT SUBSTR (Grantor, 1, ten) as grantor,--grantor of the authority
SUBSTR (GRANTEE, 1, ten) as GRANTEE,--Holder of the Authority
--G = Grantee is a group R = Grantee is a role
Granteetype,--U = Grantee is an individual user
Bindaddauth,
Connectauth,
Createtabauth,
Dbadmauth,
Implschemaauth,
Dataaccessauth,
Loadauth
From SYSCAT. Dbauth
ORDER by GRANTEE with UR "

DB2 "Select Grantee,granteetype,securityadmauth,dbadmauth,accessctrlauth,dataaccessauth from Syscat.dbauth where Grantee= ' db2inst1 ' or grantee= ' ROOT '
DB2 "Grant Secadm,dbadm,accessctrl,dataaccess on the database to user root"

Cannot manage permissions when the instance itself does not have permission to access data
. /home/db2inst1/.profile
DB2 "Select Grantee,granteetype,securityadmauth,dbadmauth,accessctrlauth,dataaccessauth from Syscat.dbauth where Grantee= ' db2inst1 ' or grantee= ' ROOT '
DB2 "Grant Secadm,dbadm,accessctrl,dataaccess on database to user Db2inst1"
DB2 "revoke secadm,dbadm,accessctrl,dataaccess on database from user root"

Database Rights Management