If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Re: Create read only access view

You can ensure that no DML operations occur by adding the WITH READ ONLY option to your view definition.
Example:
SQL> CREATE OR REPLACE VIEW myview2
AS SELECT empno, ename, sal
FROM emp
WHERE deptno=10 WITH READ ONLY OPTION;

Any attempt to perform DML on any row in the view results in an Oracle server error: ORA-01725

I would go with the first method... cos in the second one even if you create a read only view over database link, you will be actually accessing the remote db as the remote user and the remote database user will have all the access.

So any one can make changes to the table by directly accessing the table rather than the view.

Create a private database link and do read the Database Administration Manual.

Amar"There is a difference between knowing the path and walking the path."