Re: Basic Oracle Views and Tables Permissions Question.

From: <chris_at_thedunscombes.f2s.com>
Date: Fri, 15 Oct 2004 09:11:31 +0100
Message-ID: <1097827891.416f86334eaa2@webmail.freedom2surf.net>

Lydon,

As far as I'm aware it is the permissions on the underlying table(s) that count and not those on the views. BTW it should be easy for you to prove this to yourself by setting up a simple test.

Also you shouldn't be giving update/insert access to sys objects to other users. This isn't good practise. It's also not a good idea to create your own objects in sys if you've done that. The sys schema is Oracle's so we should leave it to Oracle, except for select access of course.

HTH Chris

Quoting Lyndon Tiu <ltiu_at_alumni.sfu.ca>:

> Hello,
>
> I have a table that is owned by sys and is only accessible (insert, select,
> update) to user sys.
>
> Now if I create a view on that table that is more permissible (allows select,
> insert, update) to everyone ... every user in the database.
>
> Is this possible or is the view's permission dependent on the underlying
> table's permissions?
>
> Thanks for helping.
>
> --
> Lyndon Tiu
> --
> http://www.freelists.org/webpage/oracle-l
>

Chris Dunscombe

Christallize Ltd  

---

Everyone should have http://www.freedom2surf.net/

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 15 2004 - 03:07:19 CDT