Re: Oracle user attributes

From: DA Morgan <>
Date: Thu, 06 Nov 2008 14:43:47 -0800
Message-ID: <> wrote:
> How can I find out a users attributes:
> 1. Grants currently assigned to user
> 2. Users default and temporary tablespace

Privileges can be assigned in a number of ways ... explicit grants of system and object privileges, through roles, and through roles granted through other roles.

Go to Morgan's Library at and look up:
SYSTEM PRIVILEGES Each page contains the queries required to track down the information you have requested.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Thu Nov 06 2008 - 16:43:47 CST

Original text of this message