LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 01-14-2003, 05:40 PM   #1
dorian33
Member
 
Registered: Jan 2003
Location: Poland, Warsaw
Distribution: LFS, Gentoo
Posts: 587

Rep: Reputation: 32
PostgreSQL


Hi. I've just installed the PostgreSQL so I am not familiar with it too much. So please help me to find how:
1. to list all the created database users (and their rights)
2. to forbid the users to list the names of existing databases (to list names not to connect)
3. to grant all rights to the user and to the database base if he is not the owner of the one? - I've created the database as postgres user so postrgres is the owner. The user is not admin - he could not create the database himself. But I would like to give him (and only him) the permission to create, delete, etc the tables and give him the rights to _grant_ or _revoke_ rights for another users.
Maybe the questions are stupid but in case of mySQL it took 15 minutes for me to find out the answers. In case of PostgreSQL I can't.
 
Old 01-15-2003, 09:12 AM   #2
dorian33
Member
 
Registered: Jan 2003
Location: Poland, Warsaw
Distribution: LFS, Gentoo
Posts: 587

Original Poster
Rep: Reputation: 32
I've fixed the problem (3) myself. Items 1 & 2 are still open.

Last edited by dorian33; 01-15-2003 at 09:13 AM.
 
Old 01-15-2003, 01:49 PM   #3
leed_25
Member
 
Registered: Jul 2002
Location: san francisco
Distribution: freebsd
Posts: 102

Rep: Reputation: 17
Well here's another piece (1). You want to look at the pg_shadow catalog table. Here's a url for the pg_shadow table definition:

http://www.postgresql.org/idocs/inde...pg-shadow.html

and another one for the catalogs:

http://www.postgresql.org/idocs/index.php?catalogs.html
 
Old 01-15-2003, 04:01 PM   #4
dorian33
Member
 
Registered: Jan 2003
Location: Poland, Warsaw
Distribution: LFS, Gentoo
Posts: 587

Original Poster
Rep: Reputation: 32
Thanks. I've found this chapter before but the database concept is not clear for me therefore I cannot use the information from there. First thing is that f.ex. pg_shadow can be (?) reached when I open any database. What is more this is hidden table. Very strange. In mySQL I've got the separate database 'mysql' where all configuration, user, priviliges, etc were stored and everything was obvious. Here I have possibility to acces the global tables from any database. Hm.
Very complex.

Last edited by dorian33; 01-15-2003 at 04:03 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
PostgreSql sijomon_nd Fedora 1 09-27-2005 09:27 PM
PostgreSQL 7.3.2 redhatrosh Programming 6 06-01-2005 08:15 PM
need help in postgresql yawhum80 Linux - Newbie 0 10-28-2003 10:03 AM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 02:50 AM
postgreSQL dsgdevil Linux - Software 3 02-20-2003 10:30 PM


All times are GMT -5. The time now is 07:10 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration