Re: grant select,... over schema

GRANT ALL PRIVILEGES ON databaseName To username;

Michael Lee James | Database Administrator
d. 480-282-6043| c. 480-505-5802| f. 480-505-5801
mjames@icrossinginc.com
iCrossing, Inc. | Driving the Future of Advertising
New York | Chicago | Scottsdale | San Francisco
-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org] On Behalf Of chester c young
Sent: Tuesday, February 28, 2006 9:35 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] grant select,... over schema

is there any way to grant over all applicable objects in a schema,

> grant select on schema pop to public; <-- wrong

without specifically granting the select on each table?

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to      choose an index scan if your joining column's
datatypesdo not      match 

iCrossing Privileged and Confidential Information
This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged
informationof iCrossing. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the
intendedrecipient, please contact the sender by reply email and destroy all copies of the original message.