Mike,
To the best of my knowledge you cannot list the SYS_PASSWORDS
(note this is correct name) table it is a hidden system table
and is undocumented) The same exists for SYS_COMPUTED table.
With that said if you output the AUTOCHK FULL command you can
see the following:
Examining table SYS_COMPUTED
Index: 5
Column: SYS_COLUMN_ID
Column: SYS_DATA_TYPE
Column: SYS_PCODE
Column: SYS_COLUMN_LIST
Column: SYS_ALGEBRA_DATA
Examining table SYS_PASSWORDS
Index: 6
Column: SYS_GRANTEE
Column: SYS_TABLE_ID
Column: SYS_PERM
Column: SYS_NUM_COLUMNS
Column: SYS_RELATIVE_IDS
Column: SYS_GRANTOR
Column: SYS_FLAGS
These two tables to not show in a "LIST TABLES SYS%" command.
--- MikeB <[EMAIL PROTECTED]> wrote:
> it's "SYS_PASSWORD" not "SYS_PASSWORDS"
>
> just do list SYS% to list all the system tables.
>
>
>
> ----- Original Message -----
> From: "Esbjörn Johansson" <[EMAIL PROTECTED]>
> To: "RBASE-L Mailing List" <[email protected]>
> Sent: Friday, February 01, 2008 7:03 PM
> Subject: [RBASE-L] - RE: SYS_PASSWORDS
>
>
> > Hi all
> >
> > A. Razzak Memon wrote:
> >> Use PACK PASSWORD command to clean out bogus rows from
> SYS_PASSWORDS table.
> >
> > This was interesting, as was the differing views on grants
> versus no grants.
> > I just checked one of my databases - there was NO
> sys_passwords table!
> > In this db there is an owner and grants to a number of
> users. So I did a
> > "list access for .." one of the users
> > and noticed some incomplete rows in the list. I then did a
> "pack password" -
> > got no change of size for any of
> > the db files but the incomplete rows were gone when I did a
> new "list access
> > for ..".
> >
> > We handle this database with separate "SET USER .." and
> "CONNECT dbname" and
> > never use
> > "CONNECT dbname IDENTIFIED BY username password". I have
> the impression that
> > there are
> > two different internal mechanisms handling these security
> functions.
> >
> > I would like to know more about these differences.
> >
> > Esbjorn
> >
> >
> >
>
>
>
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
