Re: Oracle permissions on View

That's exactly what I thought too!
Like in MSSQL when I give permissions to the view and that's it. No need to give permissions on the dependant objects.

I have given the user account access to the view in question, but the 'user' keeps getting this error: Insufficient Privileges. The account is fine. It can access the other tables and stuff. Is it a schema issue? 'Cos the view is the client schema and the user, in the user schema.

Help!

On Mon, 4 Sep 2006 08:06:38 +0200, "Michel Cadot" <micadot{at}altern{dot}org> wrote:

>
>"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
>

To e-mail, remove the obvious Received on Mon Sep 04 2006 - 02:13:31 CDT