I am looking for a way I can make an individual user or group of users be able to have free reign over a specific database in the postgresql system but not be able to see or modify any other of the databases installed on the system. Does anyone have any docs on how one would go about doing this. I have already found the ability to control access by machine but I have not as yet found one for users and databases. I know you can use the grant function to give users rights to certain tables but I am looking to give the user rights to the full database but only to that one database. -------------------------------------------------------------------------------- Eric Naujock CCNA, CCDA, A+, Network +, I-Net + Abacus II 5610 Monroe St. Sylvania, Ohio 43560 <http://www.abacusii.com> E-mail - [EMAIL PROTECTED] Phone - 419-885-0082 X 241 Fax : 419-885-2717 AOL IM: erlic
BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:379698.GWIA:[EMAIL PROTECTED] TEL;WORK:419-885-0082 X241 ORG:;Support TEL;PREF;FAX:419-885-2717 EMAIL;WORK;PREF:[EMAIL PROTECTED] N:Naujock ;Eric TITLE:Networking Eng. X-GWUSERID:naujocke END:VCARD BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:Eric Naujock TEL;WORK:419-885-0082 X241 ORG:;Support TEL;PREF;FAX:419-885-2717 EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED] N:Naujock ;Eric TITLE:Networking Eng. X-GWUSERID:naujocke END:VCARD
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
