Re: Role based security

Try

       grant role3 to role2 with admin option

> Hi gurus,
> I created a user user1.
> created three roles role1,2,3 identified by role1,2,3.
> What i want is that role2 must have the privilege of altering role3 only and not role1 .
> But when i issue , grant alter role3 to role2 is failing .
> But i can issue , grant any role to role2;
> So role2 can even alter the role1 . Is there any way i can resolve this.
>
> Thanks and Regards,
> Raman
Received on Wed Jun 28 2000 - 12:03:06 CDT