when I create a user "user1" and give this user the permissions on
a database "db1" (including login privilage),
this user can access all databases although it doesn't have the privilges
(even after implmenting the revoke command)
on the other hand, any user can access the database "db1"
after login, although I make (revoke all on database db1 from public ).
I need to restrict role "user1" to access only *db1* and *db2*'s *sch_a* and
*shc_f*, and also don't show the other schemas in the same database. When
listing databases, just two schemas should be shown (sch_a , sch_f).
THANKS.