RE: Default role all

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Tue, 29 Jan 2002 14:02:55 -0800
Message-ID: <F001.003FF992.20020129134552@fatcity.com>

Bill,

If the user does not have any role specifically assigned as the DEFAULT role, then all newly assigned and existing roles are DEFAULT. You do not have to do anything special to make them all DEFAULT.

On the other hand, if you have set any existing role as a DEFAULT (alter user dummy default role dummy_role;) and want to make all the newly assigned roles default, you will have to run that command you mentioned..

There is no other table/view to see the role assignment to users.

HTH,

Kirti

-----Original Message-----
Sent: Tuesday, January 29, 2002 10:01 AM To: Multiple recipients of list ORACLE-L

Hello,

Env: 8.1.6 on Solaris 2.7

Does anyone know which data dictionary table stores the setting when you issue an "ALTER USER user_name DEFAULT ROLE ALL" COMMAND?

I know that dba_role_privs has a default_role (YES/NO) field, but that is specific to each role. Is there another table that stores a system-wide default role setting per user?

The reason I ask, without getting too complicated, is that we used to assign new roles to users without specifying anything to do with default roles, and the newly-assigned role automatically became a default role. Recently, this has changed due to using both toad and sqlplus to administer roles, and I am wondering if there is another table where the system-wide default setting for roles is stored. If not, is there any way to assign new roles as default roles without having to specify "alter user user_name default role all" every time a new role is granted (or worse, an explicit list of roles)?

Thanks to any responders.
Bill Becker
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bill Becker
INET: beckerb_at_mfldclin.edu
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 29 2002 - 16:02:55 CST