Re: Oracle permissions on View

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

1/ don't top-post: post at the end of the message
2/ always give your Oracle version (4 figures, eg 10.2.0.2)
3/ copy and paste what you've done

Regards
Michel Cadot Received on Mon Sep 04 2006 - 04:14:02 CDT