I have DB2 ZOS v9 installed. We need to revoke SYSADM from couple of IDS. So before revoking, we want to create an IMPACT report. Can you please let me know what all authorities will be revoked? also, will any views or any database objects be dropped?
No database-objects and no views ( and no triggers .... ) will be dropped because of the REVOKE SYSADM. But all GRANTs that user did will be revoked, too ( and that might lead to other grants being revoked )
don't forget plans/packages. Also, take a look at making the id an installation sysadm prior to revoke as the cascade revoke will not occur. Carefully read the manual regarding cascading revokes and stick to your plan, as you could end up with a big mess of noone being able to work properly.