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)