Problem in User Securities 
Author Message
 Problem in User Securities

The default security setup in PG is to allow all connections from localhost,
w/o password. This should be changed. You'll find this in your $PGDATA
directory, in the file pg_hba.conf.

- J.

Knowledge Management & Technology Consultant

> -----Original Message-----

> Sent: Monday, May 20, 2002 5:33 AM
> To: PostgreSQL
> Subject: [ADMIN] Problem in User Securities

> 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

> ---------------------------(end of broadcast)---------------------------

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Fri, 05 Nov 2004 21:11:10 GMT
 [ 1 post ] 

 Relevant Pages 

1. Problems with user-level security

2. A Users Security problem...

3. Please help: user right & security problem

4. Security Problems in multi-user mode

5. Security Problem: All users have full access to all cubes

6. User security problem

7. Newbie - Security problem with Windows Users

8. standard security to integrated security =>problem (user sa_temp?)

9. Ambiguous user and group security

10. Confirm login user when using Integrated Security?

11. user security

12. User Security Tables

Powered by phpBB® Forum Software