Re: restrict user login to database?

Can you remove the CONNECT privilege from those users? Can you assign the CONNECT privilege based on roles, and then revoke it from something like an APP_USER role? (I'm not sure if you can assign CONNECT to roles or just users).

You could only allow connections to the listener from certain hosts as well, but that wouldn't prevent local logins.

Don.

On 12/18/06, dba1 mcc <mccdba1_at_yahoo.com> wrote:
> we have ORACLE 9ir2 on LINUX server. I knew I can
> startup database on "restrict mode" and only allow DBA
> login.
>
> Does there has other way to allow only dedicate users
> login?
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l