Re: grant select,... over schema

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