Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2011

    Unanswered: Impact of Revoking SYSADM

    Hi all,
    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?

  2. #2
    Join Date
    Dec 2005
    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 )

  3. #3
    Join Date
    Dec 2007
    Richmond, VA
    Provided Answers: 5
    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.
    Dave Nance

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts