RE: deny access to one of two databases in same instance?

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