Re: How to make a role the default?

Eugene Fan wrote:
>
> Hello All,
>
> Sorry for this dumb question, but I forgot how to make a granted role
> the default. For example,
>
> select * from dba_role_privs
> where grantee = 'HQDA_TOP_ADM'
>
> GRANTEE GRANTED_ROLE ADM DEF
> ------------------------------ ------------------------------ --- ---
> HQDA_TOP_ADM HQDA_DEF_USER YES NO
> HQDA_TOP_ADM HQDA_ORG_ADM YES NO
>
> This needs to be:
>
> GRANTEE GRANTED_ROLE ADM DEF
> ------------------------------ ------------------------------ --- ---
> HQDA_TOP_ADM HQDA_DEF_USER YES YES
> HQDA_TOP_ADM HQDA_ORG_ADM YES YES
> ^^^
<snip>

Hi

Alter user hqda_top_adm default role hqda_def_user, hqda_org_adm;

(as sys or system)

rgds
eugen Received on Mon Apr 20 1998 - 00:00:00 CDT