Re: Granting Roles

From: <bongiov_at_eglin.af.mil>
Date: Fri, 01 May 1998 08:40:42 -0600
Message-ID: <6icjcq$akb$1@nnrp1.dejanews.com>

Maybe you know this one. I grant connect to a user with admin option. That person can now grant connect to another user. However, they can not revoke it from a user. Why? How can he do this without the grant any role option?

In article <6iabes$v9e$1_at_nnrp1.dejanews.com>#1/1, bongiov_at_eglin.af.mil wrote:
>
> This could sound like a basic, fundamental question, but here goes.
>
> I have an Oracle User Account who will be granting roles to users. However,
> I want this account to only grant a subset of roles (ie: no DBA role). I
> thought about granting that account the roles with admin option. However,
> when it came time to revoke a role from the user, it failed. I don't want
to
> use the grant any role privlege because this gives the account too mach
power.
>
> Any ideas?
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 01 1998 - 09:40:42 CDT