Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Is there a difference between these two granting methods ?

Is there a difference between these two granting methods ?

From: ALEMU Abiy <abiy.alemu_at_criltechnology.com>
Date: Thu, 22 Jun 2000 14:41:28 +0200
Message-Id: <10536.110133@fatcity.com>


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 ;
        
----------------------------------------------------------------------------


@biy @lemu
Cril Telecom Software Received on Thu Jun 22 2000 - 07:41:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US