RE: Login greater than 8 Characters
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_01C39C4E.A4E06F60
Content-Type: text/plain;
charset="iso-8859-1"
Hi
logining is created in Unix not in informix
also informix doesn't stored password which is created at Os level
check sysusers table !!
Not that system tables should be modified :-(
Any ideas?
Ans) we cann't modified sysmaster/sysutils database !!
Regards
HITEN .S.BHAWSAR
-----Original Message-----
From: Zev Berezin [mailto:zevb@bhphotovideo.com]
Sent: Thursday, October 23, 2003 4:12 AM
To: informix-list@iiug.org
Subject: Login greater than 8 Characters
Hi All,
Tech Specs: IDS - 7.31.UD5W5, Solaris 8
Is there a way to have a Login greater than 8 characters?
This query against the sysmaster database lists 27 tables that seem to have
char(8) for the login.
-- SQL to list probable candidates for a login column
select tabname as Table, colname as Column
from systables, syscolumns
where systables.tabid = syscolumns.tabid and
(syscolumns.colname matches "*owner*" or
syscolumns.colname matches "*user*") and
syscolumns.collength = 8;
Not that system tables should be modified :-(
Any ideas?
TIA,
Zev Berezin
B&H Photo
Informix DBA
sending to informix-list
------_=_NextPart_001_01C39C4E.A4E06F60
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE></TITLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=153264605-27102003>Hi
</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=153264605-27102003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=153264605-27102003>logining is created in Unix not in
informix</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=153264605-27102003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=153264605-27102003>also
informix doesn't stored password which is created at Os
level</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=153264605-27102003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=153264605-27102003>check sysusers table !!</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=153264605-27102003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff><SPAN class=153264605-27102003>
<P><FONT face=Arial color=#010101 size=2>Not that system tables should be
modified :-( </FONT></P><BR>
<P><FONT face=Arial color=#010101 size=2>Any ideas? </FONT></P>
<P><FONT face=Arial color=#010101 size=2></FONT> </P>
<P><SPAN class=153264605-27102003><FONT face=Arial color=#010101
size=2>Ans)</FONT></SPAN><SPAN class=153264605-27102003><FONT face=Arial
color=#010101 size=2> we cann't modified sysmaster/sysutils database
!!</FONT></SPAN></P></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=153264605-27102003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=153264605-27102003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=153264605-27102003>Regards</SPAN></FONT></DIV>
<P><FONT face=Arial size=2>HITEN .S.BHAWSAR</FONT> <BR></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Zev Berezin
[mailto:zevb@bhphotovideo.com]<BR><B>Sent:</B> Thursday, October 23, 2003 4:12
AM<BR><B>To:</B> informix-list@iiug.org<BR><B>Subject:</B> Login greater than
8 Characters<BR><BR></FONT></DIV>
<P><FONT color=#010101>Hi All, </FONT></P><BR>
<P><U><FONT color=#010101>Tech Specs:</FONT></U><FONT color=#010101> IDS -
7.31.UD5W5, Solaris 8 </FONT></P><BR>
<P><FONT color=#010101>Is there a way to have a Login greater than 8
characters? </FONT></P><BR>
<P><FONT color=#010101>This query against the sysmaster database lists 27
tables that seem to have char(8) for the login. </FONT></P><BR>
<P><FONT color=#010101>-- SQL to list probable candidates for a login column
</FONT></P>
<P><FONT color=#010101>select tabname as Table, colname as Column </FONT></P>
<P><FONT color=#010101>from systables, syscolumns </FONT></P>
<P><FONT color=#010101>where systables.tabid = syscolumns.tabid and
</FONT></P>
<P><FONT color=#010101>(syscolumns.colname matches "*owner*" or </FONT></P>
<P><FONT color=#010101>syscolumns.colname matches "*user*") and </FONT></P>
<P><FONT color=#010101>syscolumns.collength = 8; </FONT></P><BR>
<P><FONT color=#010101>Not that system tables should be modified :-(
</FONT></P><BR>
<P><FONT color=#010101>Any ideas? </FONT></P><BR>
<P><FONT color=#010101>TIA, </FONT></P>
<P><FONT color=#010101>Zev Berezin </FONT></P>
<P><FONT color=#010101>B&H Photo </FONT></P>
<P><FONT color=#010101>Informix DBA </FONT></P><BR><BR><BR>
<P><FONT color=#010101>sending to
informix-list</FONT></P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C39C4E.A4E06F60--
sending to informix-list