Re: lost default role for all users

From: Tim Gorman <tim_at_evdbt.com>
Date: Mon, 08 Jul 2013 19:51:02 -0600
Message-ID: <51DB6C86.5060608_at_evdbt.com>

Denise,
SQL*Plus and the generic technique of "SQL-generating-SQL" makes everything easy...

    set echo off feedback off timing off pagesize 0 lineisze 130 trimout     on trimspool on
    spool run_set_/{role-name}/.sql/
    /prompt set echo on feedback on timing on     prompt spool run_set_/{role-name}
    /prompt
    select 'grant /{role-name}/to '||username||';'||chr(10)||'alter user     '||username||' default role /{role-name}/;' cmd     from dba_users order by 1;
    prompt
    prompt spool off
    prompt set echo off feedback 6 timing off     spool off
    _at_run_set_/{role-name}/

Hope this helps...

-Tim

On 7/8/2013 6:24 PM, Denise Gwinn wrote:
> One of my sites uses a default role for their baseline users. The third
> party software we use dropped and recreated that role. Now none of my
> users have a default role. I've looked and can't find a way to alter my
> users to set a default role except by one user at a time. Any ideas?
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 09 2013 - 03:51:02 CEST