pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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> 2005-09-28 11:02 ` Re: database access queries sandhya <sandhyar@amiindia.co.in> 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 10:24 database access queries bramhe manoj <manoj_bramhe@yahoo.com> @ 2005-09-28 11:02 ` sandhya <sandhyar@amiindia.co.in> 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