sumGirl
>
> Hi all. I have a server that has a single instance of
> informix but houses two production databases. I have a bunch
> of maintenance to do on one of the databases this weekend
> that will not affect the other database in any way. I am
> wondering if theres a good way or even a hack that would
> allow me to keep everyone out of one database but allow them
> in the other?
>
You could run dbschema to get all of the grants for the database.
Copy the file
Edit the new copy to disallow access to all tables except for one user
(yourself)
Run version 2 against the database.
When finished, run version 1

Colin Bull

__________________________________________________ ______________________
This email has been scanned for all known viruses by the MessageLabs Email
Security System.
__________________________________________________ ______________________

sending to informix-list