Has someone created/granted view or table/synonym for system.dual ?
-- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Frank B Hansen
Hi David
OK. Next question and some additional info:
It is only when connected as SYSTEM that 3 rows are returned. If I connect as SYS og SCOTT, only 1 row is returned.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE>Message</TITLE> <META http-equiv=Content-Type content="text/html; charset=us-ascii"> <META content="MSHTML 6.00.2800.1522" name=GENERATOR></HEAD> <BODY> <DIV><SPAN class=742005211-08112005><FONT face=Arial color=#0000ff size=2>Has someone created/granted view or table/synonym for system.dual ?</FONT></SPAN></DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV></DIV> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma size=2>-- --Original Message-- --<BR><B>From:</B> oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>Frank B Hansen<BR></FONT></DIV> <DIV>Hi David</DIV> <DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV> <DIV>OK. Next question and some additional info:</DIV> <DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV> <DIV>It is only when connected as SYSTEM that 3 rows are returned. If I connect as SYS og SCOTT, only 1 row is returned.</DIV> <DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV> <DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>
