GRANT ALL PRIVILEGES ON databaseName To username; Michael Lee James | Database Administrator d. 480-282-6043| c. 480-505-5802| f. 480-505-5801 [EMAIL PROTECTED] iCrossing, Inc. | Driving the Future of Advertising New York | Chicago | Scottsdale | San Francisco -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 datatypes do 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 information of iCrossing. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
