"Shravana Kumar" <kumar.shravana_at_blr.spcnl.co.in> wrote in message
news:3E1CE625.D9DBD06A_at_blr.spcnl.co.in...
> Hi All,
>
> 1) How to find out what are the roles assigned for a perticular user?
look in user_role_privs
>
> 2) How to find out, in which tablespace a user has been created?
Users are not created *in* a tablespace, they have a default tablespace
assigned. You can view this in dba_users. You could also look at
USER_TS_QUOTAS to find out which tablespaces the user has a disk space quota
for.
>
> 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?
I'm not sure that you can do this, though you can decrease it to 1 attempt
with 9.2 certainly and maybe in 9.0.1 as well.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu Jan 09 2003 - 09:17:56 CST
