Re: How to grant select privilages to all tables in another schema without granting "select any table to..."

Hi Daniel,

Thank you for the response. I apologize for submitting the question twice. An error occured which led me to believe that my original inquiry had failed to submit.

Mark

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3CDAD1BE.99EC2009_at_exesolutions.com...
> Mark wrote:
>
> > How can I grant, for example, select privilages to a user on all tables
or
> > other objects that exist in another schema. However, I do not want to
grant
> > select permission to tables residing in other schemas that exist in the
> > database. How can I enable this access without writing grant statements
for
> > each object in the schema in question?
> >
> > Thank you ahead of time,
> > Mark
>
> Why did you feel compelled to ask the exact same question twice using
different
> verbiage within a four minute period?
>
> The answer is the same ... you can not.
>
> The solution is to write a small anonymous block or stored procedure to
perform
> the assignments based on the table_name column in user_tables.
>
> Daniel Morgan
>
Received on Thu May 09 2002 - 16:15:24 CDT