set remot_login_passwordfile=exclusive
(create passwordfile if you don't already have one)
startup server manager connect as internal and restart the database in
restricted mode (startup restrict)
give the user that needs acces sysdba rights (or sysoper)
connect to the database as: connect <user> as sysdba
NOSPAMstannon_at_yahoo.com wrote in message
<72i19p$lr2$1_at_nnrp1.dejanews.com>...
>Hi,
>
> I am using Oracle and JDBC for developemnt. I am worried about the
>security problem and I would like to limit the database usage of JDBC
>by only one user.
>
> Is that possible to setup the listener such that it only allows one
>particular user's login?
>
>Stannon
>--
>(if you prefer E-mail, please remove "NOSPAM" from my addr)
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Nov 18 1998 - 15:50:08 CST
