I did the following: -Connect as superuser postgres with pgadmin and create a user -> noaccess CREATE ROLE noaccess LOGIN NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE;
-Disconnect from the server -Connect to the server with user 'noaccess' through pgadmin3, and I can see all databases/functions/schemas/roles. What am I missing ? On Thu, Jun 26, 2008 at 8:44 PM, Lennin Caro <[EMAIL PROTECTED]> wrote: > hello... > > you can restric acces from all the databases in your cluster. When you use > pgadmin3 this show all the databases but if you dont have access to the > databases you cant see the struct of this. > > check waht user use pgadmin3 for connect to databases > > create groups and add privileges to the group later add the users to the > group > > >
