Create read only user for Maximo DB2 database
Follow below steps
---------------------------------
- Login to the database server
- Create an operating system user 'maxread'
- Set password
- Launch DB2 command line - administrator mode
- Set db2instance=ctginst1
- Connect to db2admin user using command - connect to maxdb72 user db2admin
- Enter password
- System display connect to database
- Make concatenated query for all the tables on which select is to be granted. Format like
db2 grant select on maximo."ACCOUNTDEFAULTS" to user maxread
db2 grant select on maximo."ACTCI" to user maxread
db2 grant select on maximo."ACTCIRELATION" to user maxread
db2 grant select on maximo."ACTCISPEC" to user maxread
db2 grant select on maximo."ACTION" to user maxread
- Save it to c:\temp\tabsql.bat
- Run batch file on DB2 command line