Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Is there a difference between these two granting methods ?
Using a role :
Create role ELL_ADMIN ; Grant connect, resource to ELL_ADMIN with admin option ; Grant exp_full_database, imp_full_database, create user, drop user,alter user to ELL_ADMIN ;
Grant ELL_ADMIN to GEORGE ;
And granting the above roles directly to the user GEORGE :
Grant connect, resource to GEORGE with admin option; Grant exp_full_database, imp_full_database, create user, drop user, alter user to GEORGE ; ----------------------------------------------------------------------------
![]() |
![]() |