Re: Is there a difference between these two granting methods ?

What I know is, that if you grant dba to a user, (s)he can't create a view in someone elses schema, even though (s)he can access it. If you grant access to the table directly to the user, it is possible to create the view!

Eric Lansu

• Original Message ----- From: "ALEMU Abiy" <abiy.alemu_at_criltechnology.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, 22 June 2000 15:51 Subject: 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 ;
>
> --------------------------------------------------------------------------

--


> --------

> @biy @lemu

> Cril Telecom Software

> France

>

> --

> Author: ALEMU Abiy

>   INET: abiy.alemu_at_criltechnology.com

>

> 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).