Basic Oracle Views and Tables Permissions Question.

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 Received on Thu Oct 14 2004 - 16:53:09 CDT