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>
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