Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Role based security
Hi schmitt,
Thanks for your input . I have one doubt . What's this admin option . Will the role have any other privilege added .
regards,
Raman
From: schmitt_at_admin.uwex.edu on 28/06/2000 18:19 GMT
Please respond to ORACLE-L_at_fatcity.com
To: ORACLE-L_at_fatcity.com
cc:
Subject: 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
>
>
>
-- Author: Janet A. Schmitt 5-3334 INET: schmitt_at_admin.uwex.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Sat Jul 01 2000 - 02:09:06 CDT
![]() |
![]() |