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.James@icrossing.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