topic Re: Disabling 3 attempts while logging to SQL Plus in Operating System - HP-UX

Disabling 3 attempts while logging to SQL Plus

Sanjay Verma — Thu, 10 Oct 2002 05:12:00 GMT

Hi Friends,

When we first login to SQL Plus, it gives three attempts to login. I would like to disable it and set it to 1 attempt only. Will appreciate to know the way I can do this.

Regards,
Sanjay

Re: Disabling 3 attempts while logging to SQL Plus

T G Manikandan — Thu, 10 Oct 2002 08:17:40 GMT

The default profile is called the 'default'
So you can just do a
sql>alter profile default limit failed_login_attempts 6;
sql>alter user profile default

you can test this by creating a new profile instead of modifying the default one by
SQL> create profile prod_limit
limit failed_login_attempts 6;

SQL> create user abc identified by abcd
default tablespace temporary tablespace ;

SQL> grant create session to abc;
SQL> alter user abc profile prod_limit;

Thanks

Re: Disabling 3 attempts while logging to SQL Plus

Christian Gebhardt — Thu, 10 Oct 2002 08:22:20 GMT

Why ? Every User can type sqlplus again and has one more change.

As I know these three attempts are compiled in the sqlplus-binary, so there is no easy way to leave sqlplus after one attempt.

In a script you can use

sqlplus <user/passwd
EOF

then you have only one attempt.

Chris

Re: Disabling 3 attempts while logging to SQL Plus

Christian Gebhardt — Thu, 10 Oct 2002 08:25:47 GMT

If you change the profile in the database you disable the User in the database so nobody can login with this user.

Leaving sqlplus after three attempts does not disable the user in the database.

Chris

Re: Disabling 3 attempts while logging to SQL Plus

Sanjay Verma — Thu, 10 Oct 2002 22:07:26 GMT

Hello TG & Everyone,
Is there a way I can make one attempt the default for every user?
~Sanjay

Re: Disabling 3 attempts while logging to SQL Plus

Bala_8 — Fri, 11 Oct 2002 00:23:01 GMT

Hi Sanjay,

This is referred as BUG-381695 by Oracle... a request for enhancement was requested by Oracle but it was rejected ... You can refer oracle sites to find details about this bug ..

There is no direct solution to achive this ...

U can try this:

Make users connect to the database using procedures/passing parameters ... when the first connections fails with the password passed as parameter, use WHENEVER SQL ERROR Exception and close the connection ...

this approach may be suitable for batch jobs like things but for every sqlplus connection by user you may not achieve the results ....

Look in the oracle sites for more info ...

cheers
-bala-