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
> ^^^
>
> I know this is kinda of RYFM, but somebody walked off with our copy
> of the Server Admin manual and the other books, like the SQL Lanquage
> Reference, weren't very helpful. Thanks in advance for any help.
>
> --
> Eugene Fan
> fane_at_hqda.army.mil
> eugenef_at_tidalwave.net

alter user xxx default role yyy1 {, yyy2] ...

Cheers,
Erica Harris
Oracle DBA/System Administrator
Environment Waikato
Hamilton
New Zealand Received on Tue Apr 21 1998 - 00:00:00 CDT