| From: | chester c young <chestercyoung(at)yahoo(dot)com> |
|---|---|
| To: | Michael James <Michael(dot)James(at)icrossing(dot)com>, sql pgsql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: grant select,... over schema |
| Date: | 2006-02-28 17:10:47 |
| Message-ID: | 20060228171047.36374.qmail@web54312.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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 <Michael(dot)James(at)icrossing(dot)com> wrote:
> GRANT ALL PRIVILEGES ON databaseName To username;
>
>
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Caune | 2006-02-28 23:49:25 | plsql / time statement |
| Previous Message | Michael James | 2006-02-28 16:43:58 | Re: grant select,... over schema |