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)