Not possible in one view. If I wanted a view for each table I would write a
wizard that iterated through a list of the tables and produced a script that
I could execute on the database. We do this for replication.

But if you want them to be able to select all from the database, can't you
grant this explicitly on the tables themselves, why do you need views?

Cheers,

JAC

""rodbracher"" <rod@...> wrote in message
news:a1jhut+adcm@......

> Hi
>
> I need to create a 'Select' only view for a group of users for the
> entire db.
>
> I assume I create a role for the users with the granted privelege
> of 'select' and assign to the view. (Correct me if I am wrong please )
> What is the simplest way of assigning a view of the entire database

> It is large - so I do not want to list each table )
>
> Thanks - Rod
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>