RE: Can't find user DB permissions
Posted in 2000
Topics: General Discussion
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C03F83.4B3EF81C Content-Type: text/plain; charset="windows-1252" Which priveleges are you talking about? Database only or are you interested in tables, columns, procedures, fragments and roles too? You can query the following system catalog tables: sysusers database systabauth tables syscolauth columns sysprocauth procedures sysfragauth fragments sysroleauth roles B......MAN -----Original Message----- From: Frank Louvado [mailto:frank.louvado@hunterdouglas.com] Sent: Thursday, October 26, 2000 12:17 PM To: informix-list@iiug.org Subject: Can't find user DB permissions How can you get a listing of all users and their DB privileges? I'm assuming it's in an SMI table somewhere but I can't find it... Anyone know??? ------_=_NextPart_001_01C03F83.4B3EF81C Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dwindows-1252"> <META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD> <BODY style=3D"FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px; MARGIN-TOP: = 2px"> <DIV><FONT size=3D1><SPAN class=3D788492419-26102000>Which priveleges = are you=20 talking about? Database only or are you interested in tables, = columns,=20 procedures, fragments and roles too? You can query the following = system=20 catalog tables:</SPAN></FONT></DIV> <DIV><FONT size=3D1><SPAN = class=3D788492419-26102000></SPAN></FONT> </DIV> <DIV><FONT size=3D1><SPAN=20 class=3D788492419-26102000>sysusers &= nbsp; databas= e</SPAN></FONT></DIV> <DIV><FONT size=3D1><SPAN=20 class=3D788492419-26102000>systabauth  = ; =20 </SPAN></FONT><FONT size=3D1><SPAN=20 class=3D788492419-26102000>tables</SPAN></FONT></DIV> <DIV><FONT size=3D1><SPAN=20 class=3D788492419-26102000>syscolauth  = ; =20 columns</SPAN></FONT></DIV> <DIV><FONT size=3D1><SPAN=20 class=3D788492419-26102000>sysprocauth &nbs= p; =20 procedures</SPAN></FONT></DIV> <DIV><FONT size=3D1><SPAN=20 class=3D788492419-26102000>sysfragauth &nbs= p; fragments</SPAN></FONT></DIV> <DIV><FONT size=3D1><SPAN=20 class=3D788492419-26102000>sysroleauth &nbs= p; roles  = ; </SPAN></FONT></DIV> <DIV><FONT size=3D1><SPAN = class=3D788492419-26102000></SPAN></FONT> </DIV> <DIV><FONT size=3D1><SPAN = class=3D788492419-26102000></SPAN></FONT> </DIV> <DIV><FONT size=3D1><SPAN=20 class=3D788492419-26102000>B......MAN = </SPAN></FONT></DIV> <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"> <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20 size=3D2>-----Original Message-----<BR><B>From:</B> Frank Louvado=20 [mailto:frank.louvado@hunterdouglas.com]<BR><B>Sent:</B> Thursday, = October 26,=20 2000 12:17 PM<BR><B>To:</B> informix-list@iiug.org<BR><B>Subject:</B> = Can't=20 find user DB permissions<BR><BR></DIV></FONT> <DIV>How can you get a listing of all users and their DB = privileges?</DIV> <DIV>I'm assuming it's in an SMI table somewhere but I can't find = it...</DIV> <DIV> </DIV> <DIV>Anyone know???</DIV></BLOCKQUOTE></BODY></HTML> ------_=_NextPart_001_01C03F83.4B3EF81C--