Re: Oracle user attributes

From: ddf <>
Date: Thu, 6 Nov 2008 12:29:10 -0800 (PST)
Message-ID: <>

Comments embedded.
On Nov 6, 1:28 pm, 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