Re: Oracle user attributes
Date: Thu, 06 Nov 2008 14:43:47 -0800
> 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 www.psoug.org and look
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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Nov 06 2008 - 16:43:47 CST