pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
database access queries
2+ messages / 2 participants
[nested] [flat]

* database access queries
@ 2005-09-28 10:24  bramhe manoj <manoj_bramhe@yahoo.com>
  0 siblings, 1 reply; 2+ messages in thread

From: bramhe manoj @ 2005-09-28 10:24 UTC (permalink / raw)
  To: pgsql-admin

hi ,

we are working as linux administrators in enng college
in mumbai(india). 

we have created databases in postgresql for all staffs
& students & granted them with permissions & password

query :

how to restrict database user from accessing other
users databases? 

here we are  getting problem that any user can access
database of other users 

pls tell us  how we can do in postgresql

bye


prof bramhe
prof pandagre 


		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: database access queries
@ 2005-09-28 11:02  sandhya <sandhyar@amiindia.co.in>
  parent: bramhe manoj <manoj_bramhe@yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: sandhya @ 2005-09-28 11:02 UTC (permalink / raw)
  To: bramhe manoj <manoj_bramhe@yahoo.com>; +Cc: pgsql-admin

----- Original Message ----- 
From: "bramhe manoj" <manoj_bramhe@yahoo.com>
To: <pgsql-admin@postgresql.org>
Sent: Wednesday, September 28, 2005 3:54 PM
Subject: [ADMIN] database access queries


> hi ,
>
> we are working as linux administrators in enng college
> in mumbai(india).

>
> we have created databases in postgresql for all staffs
> & students & granted them with permissions & password

   Are all users have superuser permission ?

>
> query :
>
> how to restrict database user from accessing other
> users databases?

    Accessing other user's database......IS it mean getting the table info
of other user's database?
>
> here we are  getting problem that any user can access
> database of other users
>
> pls tell us  how we can do in postgresql

See:
 \du
              List of database users
 User name | User ID |         Attributes
-----------+---------+----------------------------
 postgres    |         1 | superuser, create database
 root           |     100 | superuser, create database
 sampledb   |     103 |

If you have a user of 'sampledb' with no superuser permission..he can't
access the tables of other user's database.
Check the permissions and the login info.
>
> bye
>
>
> prof bramhe
> prof pandagre
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-09-28 11:02 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-28 10:24 database access queries bramhe manoj <manoj_bramhe@yahoo.com>
2005-09-28 11:02 ` sandhya <sandhyar@amiindia.co.in>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox