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