Re: Oracle user attributes

From: ddf <oratune_at_msn.com>
Date: Thu, 6 Nov 2008 12:29:10 -0800 (PST)
Message-ID: <328f923c-454b-463f-b64e-9e411b924c29@b38g2000prf.googlegroups.com>


Comments embedded.
On Nov 6, 1:28 pm, haganahtrai..._at_gmail.com wrote:
> How can I find out a users attributes:
>

Walk over to his/her desk and get a good look?

> 1. Grants currently assigned to user
>

Look into the DBA_ROLE_PRIVS view, since I imagine you won't be connected as this particular user.

> 2. Users default and temporary tablespace

DBA_USERS has that information. You simply need to go and get it.

David Fitzjarrell Received on Thu Nov 06 2008 - 14:29:10 CST

Original text of this message