Re: single-user mode
Posted in 2000
Sujit.Pal@bankofamerica.com — — source: Informix-list mailing list archive (1991-1998)
Graeme
Dont think that there is a way to do this directly, but you can simulate a
single user mode like this:
revoke permissions on all objects from all users except the one which will runthe "single user" job.
bring database to queiscent mode and back up.
run your "single-user" operations
grant the pernissions back
HTH
Sujit
Graeme Muirhead <g.muirhead@freeuk.com> on 05/05/2000 01:03:23 PM
Please respond to Graeme Muirhead <g.muirhead@freeuk.com>
To: informix-list@iiug.org
cc:
Subject: single-user mode
Is it possible to go into 'single-user mode' in ODS 7.23? I need to deny
access to other users while running SQL queries, so quiescent mode won't do.
Thanks
Graeme Muirhead
g.muirhead@freeuk.com