Re: Default Roles vs Granted Roles

From: John P. Higgins <jh33378_at_deere.com>
Date: 1998/10/28
Message-ID: <3637DAE6.560BD12B@deere.com>#1/1

SQL Manual:

The DEFAULT ROLE clause can only contain roles that have been granted directly to the user with a GRANT statement. You cannot use the DEFAULTROLE clause to enable:

roles not granted to the user

roles granted through other roles

Bruce M Krawetz wrote:

> Hello
>
> What is the difference between default roles (those done by "ALTER USER")
> and roles granted to a user (those done by GRANT role TO user)?
>
> Is it a matter of permissions? (i.e. someone can ALTER USER, but
> cannot GRANT).
>
> Can an ALTER USER ever have WITH ADMIN OPTION?
>
> Can a default role be REVOKED (or can it only be done via another ALTER USER)?
>
> Or is the ALTER USER a legacy command?
>
> enQUERYing mind want to know!
>
> --
> ------------------------------------------- bmk_at_wdl.lmco.com
> We must learn from our mistakes, so we can make bigger and better ones.
Received on Wed Oct 28 1998 - 00:00:00 CST