Re: How to hide databases?
Heckers wrote:
>
> Hello!
>
> We are using Informix and everybody gets a list of all databases if he
> takes a look with dbaccess->select->databases.
> There are some databases which are only for a few guys supporting a different
> produkt.
> Is it possible to 'hide' databases that someone doesn't need to know about?
> I read about dbspaces but I found nothing about what happens if I use
> different dbspaces.
> I found a way by starting Informix with a different SERVERNUM, but the
> machine (SUN-Ultra-Sparc) is very slow after starting the second set
> of oninit procs.
>
> Thankx,
> Erik
The databases you can see in dbaccess are the databases listed in the
file
$INFORMIXDIR/etc/sqlhosts
What you can do is create more sqlhosts files with different content and
then set
the environment variable INFORMIXSQLHOSTS to the sqlhosts file with the
databases
you want to be visible.
Remember, to be able to see the name of a database in dbaccess, is not
the same
as having connect permission to the database. So maybe you should also
consider
GRANT/REVOKE CONNECT. There's also some quite nice things you can do
with the
CREATE/SET ROLE facility.
best regards
--
+-------------------------------------------------------------+
| Claus Samuelsen Sysdeco Danmark A/S |
| Project Manager Gydevang 22B |
| email: csa@sysdeco.dk DK-3450 Aller'd |
| phone: +45 4814 3000 Denmark |
+-------------------------------------------------------------+