Re: dissallowing access to databases

Pawel,

> How can I prevent user from connecting to certain databases?

IIRC, users are server-wide, so there's no way to. To protect your tables,
you normally do something like:

create table blabla(
<...>
);

revoke all on blabla from public;
grant select on blabla to blabla_user;

As long as data dictionary is also kept in relations, you should be able
to protect it that way, too. It seems that only DB superusers and owners
have insert/delete rights on data dictionary.

Ed

---
Well I tried to be meek
And I have tried to be mild
But I spat like a woman
And I sulked like a child
I have lived behind the walls
That have made me alone
Striven for peace
Which I never have known

Dire Straits, Brothers In Arms, The Man's Too Strong (Knopfler)