[Info-ingres] RE: [ingres] [Info-ingres] Dates users were created in Ingres

Hi Paul,  

Thanks for the information!  I do have a question:  I checkpoint the
iidbdb daily with the -d flag, so the journal files don't exist for me
that far back (to cover all of 2004).  If I weren't using the -d flag,
how far back would Ingres track Journal/Checkpoint information?
Indefinitely?  I have a limited amount of space in my jnl file system,
so I doubt I could keep a year's work of jnl files for that database
even if I weren't using the -d flag.


-----Original Message-----
From: Paul Mason [mailto:latepaul@gmail.com] 
Sent: Sunday, January 16, 2005 4:32 PM
To: Anderson, Troy E.
Cc: info-ingres@cariboulake.com
Subject: Re: [ingres] [Info-ingres] Dates users were created in Ingres

Anderson, Troy E. wrote:

> Hi,
> Does anyone know if Ingres tracks the date that a user was created (in
> accessdb)?  Is that contained in a system catalog, for example?  I'd 
> like to figure out all new user accounts created in 2004...
> Thanks,
> *Troy E. Anderson*
> *BV SOLUTIONS GROUP, Inc.*, A Black & Veatch Company
> 10950 Grandview Ave.
> Overland Park, KS 66210
> Tel. (913) 458-8521
> Fax. (913) 458-4994
> <_mailto: andersonte@bvsg.com_ <mailto:%20%20andersonte@bvsg.com>>
> Visit us: _http://www.bvsg.com_
Try this -

auditdb -a -table=iiuser iidbdb

iidbdb should be journalled so this should tell you what you need to


1/17/2005 4:57:01 AM
comp.databases.ingres 5857 articles. 0 followers. specially (35) is leader. Post Follow

0 Replies

Similar Articles

[PageSpeed] 58