Re: basic oracle questions.

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Thu, 09 Jan 2003 08:58:06 -0800
Message-ID: <3E1DAA1E.A4613A0D@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.

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 - 10:58:06 CST