Hey James and Ed!

It's been a long time since I worked on mainframe DB2, but doesn't the system programmer who installed DB2 and set the DSNZPARMS have the INSTALLADM privilege who then also grants the SYSADM privilege? Back in the day it used to be INSTALLADM was an outside-the-catalog privilege and SYSADM was the highest through-the-catalog privilege possible; you won't find INSTALLADM anywhere in the catalog. But if you leave enough donut crumbs out, I think you'll find the culprit!

Nick

-------------- Original message --------------
From: "Edwards Ed " <db2udbdba-ezmlmshield-x87177007.[Email address protected]

> Hey JAMES PARK,
> Just a guess, but I think db2admin or whoever has the "big userid and
> password" (used when creating the database) can give SYSADM rights.
>
>
>
>
> Please take a few minutes to provide feedback on the quality of service you
> received. The Department of Education values your feedback as a customer.
> Commissioner John L. Winn is committed to continuously assessing and improving
> the level and quality of services provided to you by Department staff. Simply
> use the link below. Thank you in advance for completing the survey.
>
>
> http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
>
>
>
>
> -----Original Message-----
> From: JAMES PARK
> [mailto:db2udbdba-ezmlmshield-x48734883.[Email address protected]
> Sent: Tuesday, February 27, 2007 3:19 PM
> To: LazyDBA Discussion
> Subject: Grantor of SYSADM
>
> Listers.
>
> v8 on z/OS.
>
> I can find who SYSADMs are in DSNZPARM.
>
> But how can I find who gave SYSADM?
>
>
>
> Thanks,
>
> James Park
> Database Specialist II
> Annapolis Data Center
> 410-260-7489
> [Email address protected]
>
> ------------------------------------------------------------------------
> ------
> This email and any file transmitted with it may be confidential and are
> intended solely for the use of the individual or entity to whom they are
> addressed. If you received this email in error, please notify the
> Comptroller's System Manager by forwarding this message to [Email
> address protected]
> ========================================================================
> ======
>
>
>
> This footnote also confirms that this email message has been swept by
> the networkmaryland MIMEsweeper for the presence of computer viruses.
>
> **********************************************************************
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>

DB2 & UDB email list listserv db2-l LazyDBA home page