kartik wrote:
Hello there,
Can anyone tell me the differences between postgresql 8.1 and
postgresql 8.3.3
Thanks
Waiting for your reply
Sure, just have a look here:
http://www.postgresql.org/docs/8.3/static/release-8-3.html
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consult
These docs are pretty good... .. release notes..
http://www.postgresql.org/docs/8.3/static/release.html
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kartik
Sent: Friday, June 27, 2008 12:33 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Query
My users will not need to use pgadmin3, the whole problem is any user with
login access to a postgresql server can use pgadmin3 to connect and see all
databases/roles/functions/table-definitions/schemas. This is not a problem
with pgadmin3 but with postgresql server.
Look at it in a general way so
Hello there,
Can anyone tell me the differences between postgresql 8.1 and postgresql
8.3.3
Thanks
Waiting for your reply
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
in pgadmin3:
Menu -> Display
check the option "System Object"
this show you the catalogs of postgresql "pg_"
change the grants to users here
--- On Fri, 6/27/08, Domingo Alvarez Duarte <[EMAIL PROTECTED]> wrote:
From: Domingo Alvarez Duarte <[EMAIL PROTECTED]>
Subject: Re: [ADMIN] Exte
Ok...
the catalog of tables, function and roles are public. Pgadmin use the catalog
to create the tree of databases, function and roles. The user can see this but
cant change this. In oracle the catalog of user, tables, function are public
--- On Fri, 6/27/08, Domingo Alvarez Duarte <[EMAIL PR
ok, let try this .
open the pg_hba.conf and check the line
host all all 127.0..0.1/32 trust
and change to
host all all 127.0..0.1/32 password
--- On Thu, 6/26/08, Domingo Alvarez Duarte <[EMAIL PROTECTED]> wrote:
From: Domingo Alv
