Role based security

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 - 04:51:30 CDT