Oracle permissions on View

From: AcCeSsDeNiEd <dillon_at_SpamMinuSaccessdenied.darktech.org>
Date: Mon, 04 Sep 2006 13:47:36 +0800
Message-ID: <9oenf2d8heinluqlocq6k7gnijuk3uor8l@4ax.com>

Is there some easy & straight forward way to give an user account access to a view? By which it should automatically give access to all the related tables & objects?

I have a view that is connected to several tables, schemas and views. I'm pretty sure that I have given access to all these connected tables & views but I still get a permission error when trying to access this view with the said account.

I saw the dependant objects and gave access to each one via the dependant list of the view in question.

Thx

To e-mail, remove the obvious Received on Mon Sep 04 2006 - 00:47:36 CDT