Re: Oracle user attributes
Date: Thu, 6 Nov 2008 12:29:10 -0800 (PST)
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