how to disable a database
there are two database on a instance. How to disable a database and left the other database enabled ? It mean that I won't allow a group of user to access the specified database temporarily.
Revoke connect, resource, and dba priveleges from PUBLIC and all usersexcept user informix.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Wed, Dec 12, 2012 at 8:58 PM, joe <joeclhua@gmail.com> wrote:
> there are two database on a instance.
>
> How to disable a database and left the other database enabled ?
>
> It mean that I won't allow a group of user to access the
> specified database temporarily.
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
Hello Joe,
i would use sysdbopen in this case
be careful and check the manual for this, there is an env var to
skip sysdbopen.
anyways:
create procedure "informix".sysdbopen()
end procedure:
create procedure "public".sysdbopen()
define mycount int:
select count(*) into mycount from superboerdoesnotexist:
end procedure;
this will cause an exception 206 and will not let you in.
hmm make sure superboerdoesnotexist is really not there
See you
Superboer.
Am Donnerstag, 13. Dezember 2012 02:58:06 UTC+1 schrieb joe:
> there are two database on a instance.
>
> How to disable a database and left the other database enabled ?
>
> It mean that I won't allow a group of user to access the
> specified database temporarily.