From: | David Rickard <David(dot)Rickard(at)GTScompanies(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Cc: | Judith Strawser <judiths(at)GTScompanies(dot)com> |
Subject: | Access Privileges |
Date: | 2003-10-16 17:15:47 |
Message-ID: | 5.2.1.1.0.20031016101239.03260cd0@mail.gtscompanies.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Is there any shorthand for granting access privileges (select etc) to all
of the tables/views in a database or schema en masse? I have attempted
"grant select on <schema>.* to <user>" and get "ERROR: Relation
"<schema>"."*" does not exist" as a result;
--
David Rickard
Software Engineer
The GTS Companies
A TechBooks Company
----------------------------------------------------------------------------------
The GTS Companies:
GTS Publishing Services, GTS Graphics, GTS Innova:
Your Single-Source Solution!
Los Angeles CA * York, PA * Boston MA * New Delhi, India
----------------------------------------------------------------------------------
David(dot)Rickard(at)GTSCompanies(dot)com
Visit us on the World Wide Web
http://www.gtscompanies.com
5650 Jillson St., Los Angeles, CA 90040
(323) 888-8889 x331
(323) 888-1849 [fax]
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-10-16 17:40:33 | Re: Access Privileges |
Previous Message | Bruno Wolff III | 2003-10-16 17:11:25 | Re: variable date precision |