Yep.. Check my other missive that led to the error of my ways. Yesterday wasn't my finest.
Thanks James, Mike ----- Original Message ----- From: "James Bentley" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Friday, February 01, 2008 11:14 PM Subject: [RBASE-L] - RE: SYS_PASSWORDS > 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 > > >
