| From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
|---|---|
| To: | "Craig Jarman" <cjarman(at)source(dot)com(dot)au>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Error: Relation 'testdb' does not exist |
| Date: | 2001-10-29 17:23:05 |
| Message-ID: | NEBBLAAHGLEEPCGOBHDGEEICDNAA.nickf@ontko.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> 3. psql testdb
> 4. GRANT ALL ON testdb TO administrator
> At this point an error is returned - "Error: Relation 'testdb' does not
exist"
This is because testdb is the database, not an object in the database. You
can grant priveleges on individual objects in the db, but not the entire db.
(Inconvenient, but it's pretty easy to write a script to create a set of
grants.)
-Nick
--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2001-10-29 18:46:00 | Re: Error: Relation 'testdb' does not exist |
| Previous Message | George Eric R Contr AFSPC/CVYZ | 2001-10-29 16:29:59 | Re: Ultimate DB Server |