Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Basic Oracle Views and Tables Permissions Question.

Basic Oracle Views and Tables Permissions Question.

From: Lyndon Tiu <ltiu_at_alumni.sfu.ca>
Date: Thu, 14 Oct 2004 14:57:36 -0700
Message-Id: <200410142157.i9ELvaO2010210@rm-rstar.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 Received on Thu Oct 14 2004 - 16:53:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US