Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to Forbid sqlplus connecting to ORACLE
Grant. You will need to embed the security of the application in the
database it self. Let users get into the applications through Stored
procedures and grant execute on these SPs to the users. users can then
never use SQL Plus or any third party tool -- Access etc through ODBC
to get into the application Hope this helps.
"Grant" <goddabao_at_yahoo.com> wrote in message news:<bcp5la$gt_at_netnews.proxy.lucent.com>...
> Hi,
>
> Does anyone know how to forbid sqlplus connecting to ORACLE Server?
> I don't want somebody using my DB Server via sqlplus in Client, and I will
> only permit the user using svrmgrl on the Host.
>
> The ORACLE Server version is 8.1.7 (another is 8.1.5), running on Solaris.
>
> Thanks
> Best Regards,
>
> Grant
Received on Wed Jun 18 2003 - 19:59:41 CDT