Privileges granted by roles

From: John Dunn <JDunn_at_sefas.com>
Date: Tue, 21 Apr 2015 09:51:21 +0000
Message-ID: <EEC3316514CFB24AB2285394E0D405587C87BFE3_at_BOU.sefasuk.local>

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

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

Received on Tue Apr 21 2015 - 11:51:21 CEST