Re: QUESTION: Stop 9i db from auto-registering in listener

bdbafh_at_gmail.com wrote:
>
> Connor,
>
> The behavior of restricted mode changed in 10g R1.
> >From what I have observed, only connections as sysdba are permitted.
> An account having been granted the sys_priv "restricted session" is not
> sufficient for connecting, so using multiple listeners, with the one
> servicing known ports being down if a non-sysdba account is used for
> maintenance.
>
> -bdbafh

Can you elaborate ? I did the following on 10.2

SQL> grant create session, restricted session to demo   2 identified by demo;

Grant succeeded.

SQL> alter system enable restricted session;

System altered.

SQL> conn demo/demo
Connected.
SQL> conn scott/tiger
ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

Warning: You are no longer connected to ORACLE.

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------