Re: Privileges granted by roles

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Tue, 21 Apr 2015 13:17:26 -0400
Message-ID: <55368626.5090505_at_yahoo.com>

On 04/21/2015 05:51 AM, John Dunn wrote:
>
> Am I correct in saying that granting the following to a user will NOT
> grant them CREATE ANY TABLE or SELECT ANY TABLE privileges?
>
> GRANT RESOURCE TO JOHN;
> GRANT CREATE SESSION TO JOHN;
> GRANT CONNECT TO JOHN;
>
> …i.e. the user JOHN will NOT be able to perform select or create table
> on another schema?
>
> Am I correct?
>
> *John *
>

In version 11G, the RESOURCE role is essentially meaningless. Grant connect is the same as "CREATE SESSION". John will have a privilege to connect to database and see everything that's granted to him or to public.

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 21 2015 - 19:17:26 CEST