Re: Oracle permissions on View

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 4 Sep 2006 08:06:38 +0200
Message-ID: <44fbc270$0$29461$626a54ce@news.free.fr>

"AcCeSsDeNiEd" <dillon_at_SpamMinuSaccessdenied.darktech.org> a écrit dans le message de news: 9oenf2d8heinluqlocq6k7gnijuk3uor8l_at_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

One of the purposes of the views is to hide underlying objects. You give access to view without giving access to dependant objects.

Have a look at Concepts manual, chapter 5 "Schema Objects", section "Overview of Views":

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.htm#i20690

Regards
Michel Cadot Received on Mon Sep 04 2006 - 01:06:38 CDT