Problem in User Securities - Mailing list pgsql-admin

From shreedhar
Subject Problem in User Securities
Date
Msg-id 004101c1ffe1$454f3d70$1201a8c0@a4005
Whole thread Raw
Responses Re: Problem in User Securities
List pgsql-admin
Hello All,

I am new to Postgres, While I was checking 'User Securities' in postgres I
got the following problem.

I created a user using 'createuser' command and gave superuser permissions.

but while accessing database, even if we have not given   '-W' password
option it is entering into database. So who knows Unix administrator
password can enter into any database if they know corresponding login name
and they work with the same permissions..

And also i observed that even we can enter into template1 with out giving
any username or password.

I doubt there will be a way to restrict this.

Can any body help me regarding this.

Thanks alot,

With best Regards
bhaskararaju



pgsql-admin by date:

Previous
From: Jean-Michel POURE
Date:
Subject: UTF-8 safe ascii() function
Next
From: "Gareth Kirwan"
Date:
Subject: Interval to number