Re: 9iDB Security Hole?

In article <3cbbfa1a$0$15478$afc38c87_at_news.optusnet.com.au>, Nuno says...
>
>In article <3CBBC7ED.5CC5241B_at_oracle.com>, you said (and I quote):
>>
>> Don't try this at home without adult supervision:
>
>
>Hehehe! Bugger!
>Hmmm, been finding a few weird ones too. Mainly to do with using
>functions in SQL and null values that should be returned by them. Weird,
>very weird...
>Roll on Release 2?

Yep, it's a known bug with the ANSI syntax (bug ID from HJR 2121935), fixed in the next release (well, 9.2 anyway). Here's your proofpoint:

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Apr 16 07:30:31 2002

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
Connected.
SQL> create user us1 identified by us1;

User created.

SQL> grant create session To us1;

Grant succeeded.

SQL> connect us1/us1
Connected.
SQL> select a.userid, a.password
2 from sys.link$ a left outer join sys.link$ b on b.name= a.name ; from sys.link$ a left outer join sys.link$ b on b.name= a.name

         *
ERROR at line 2:
ORA-00942: table or view does not exist

>
>
>--
>Cheers
>Nuno Souto
>nsouto_at_optushome.com.au.nospam

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Tue Apr 16 2002 - 10:00:57 CDT