Re: [SQL] grant select,... over schema

2006-03-01 Thread Bruno Wolff III
] 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;

Re: [SQL] grant select,... over schema

2006-02-28 Thread Michael James
: [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 pub

Re: [SQL] grant select,... over schema

2006-02-28 Thread chester c young
do not want to grant ALL PRIVILEGES to user, only SELECT - do not want PUBLIC to have any dml priveleges on this schema --- Michael James <[EMAIL PROTECTED]> wrote: > GRANT ALL PRIVILEGES ON databaseName To username; > > > is there any way to grant over all applicable objects in a schema, > >

[SQL] grant select,... over schema

2006-02-28 Thread chester c young
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