Re: Automatically enabled roles

Peter wrote:
>
> On Thu, 29 May 2003 07:16:24 +0200, Sybrand Bakker
> <gooiditweg_at_sybrandb.demon.nl> wrote:
>
> >On Thu, 29 May 2003 00:17:55 GMT, Peter <peter_at_nomorenewsspammin.ca>
> >wrote:
> >
> >>On Wed, 28 May 2003 22:54:52 GMT, "Oradba Linux"
> >><oradba_linux_at_attbi.com> wrote:
> >>
> >>>On Wed, 28 May 2003 21:46:35 +0000, Peter wrote:
> >>>
> >>>> Is it possible to grant a role to a user so that it is automatically
> >>>> enabled when the user logs on the next time?
> >>>>
> >>>> Thanks
> >>>A granted role is automatically enabled to a user when he logs in
> >>>next time . Did you notice otherwise ?
> >>
> >>I was thinking that you can grant roles to a user, but at the same
> >>time the role can remain disabled for the user after granting. The
> >>enabling has to done by the DBA explicitly or set to be enabled after
> >>a period of time.
> >
> >
> >You should not think you should READ THAT MANUAL and STOP ASKING
> >OBVIOUS QUESTIONS
> >
>
> I read it already, needless to say.

There are two distinct concepts:

• what roles the user has
• whether they are active at a given time

Check out the default enabled roles doco and the 'set role' command

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"