Re: Restricting internal access to users.

jmkuruvilla_at_yahoo.com (jiju) wrote in
news:c396a971.0308110815.fb428af_at_posting.google.com:

> hello,
>
> How do I restrict internal account access to database users? I created
> a user called user1 and granted him connect and resource privileges.
> Now after I connect as user1, I tried 'connect internal' and I get
> connected to the database as 'SYS' which is dangerous. How can I
> restrict this such that when user1 tries to 'connect internal' it will
> prompt for the password. Please help.
>
> Thanks in advance.
>
> jiju
>

The only people who can connect internal (or "as sysdba") without a password are those in the operating system's DBA group. Remove non-dba users from the DBA group. Received on Mon Aug 11 2003 - 11:39:45 CDT