Re: basic oracle questions.

Profiles certainly have a "failed_login_attempts" limit which can be set to 2 for example.

However, it works by locking the user account after the second failure, not by barring the user having other attempts (though all such other attempts will fail, of course).

It is also possible to have Oracle automatically unlock the user account after a set period of time. Limit "account_lock_time" to "1/1440", for example, and the account will be locked for one minute before being automatically unlocked.

For the original poster, the full command would therefore look like:

create profile blah limit
failed_login_attempts 2
account_lock_time 1/1440;

alter user fred profile blah;

Regards
HJR "DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E1DAA1E.A4613A0D_at_exesolutions.com...
> Shravana Kumar wrote:
>
> > Hi All,
> >
> > 1) How to find out what are the roles assigned for a perticular user?
> >
> > 2) How to find out, in which tablespace a user has been created?
> >
> > 3) Normally, we should be able to connect to oracle using sqlplus in 3
> > attempts. I would like to decrese this to 2 attempts. How to achieve
> > this?
> >
> > we are using oracle 9.0.1 on sun solaris version 8.
> >
> > thanks a lot,
> >
> > Best Regards,
> > ShravanaKumar.
>
> 1. SELECT object_name
> FROM all_objects
> WHERE object_name LIKE '%PRIV%';
>
> substitute ROLE for PRIV and find more related objects. Look them
> over.
>
> 2. Users don't create or own tablespaces. Are you trying to find out
> what tablespaces the user has been granted a quota on?
>
> Modify the above query and you will find it.
>
> 3. Don't know that you can nor why you would care. But go to
> http://tahiti.oracle.com and seach under "PROFILE".
>
> Finally. Get off 9.0.1 it is fraught with problems. The upgrade to 9.2 is
> free.
>
> Daniel Morgan
>
Received on Thu Jan 09 2003 - 12:54:16 CST