Login greater than 8 Characters
<color><param>0100,0100,0100</param>Hi All,
<underline>Tech Specs:</underline> 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
[SNIP] > > Is there a way to have a Login greater than 8 characters? > [SNIP] No way. Since IDS is using OS users and primary OS for Informix is UNIX, ... > > Any ideas? > You can use your own authentication system, but it will take you quite a lot of programming to do it. Is it worth it? Gorazd
On Wed, 22 Oct 2003 18:41:58 -0400, Zev Berezin wrote:
First Please do no post HTML, etc., many, like me, do not use a browser to read
the news group or mail gateways for that matter.
The solution is to upgrade to 9.xx where database identifiers (ie database,
table, and column names) were increased from 18 characters to 128 characters
and usernames and other external identifiers were increased from 8 chars to 32
characters.
Art S. Kagel
> 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