| 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 ;
----------------------------------------------------------------------------
![]() |
![]() |