Privileges granted by roles

  • From: John Dunn <JDunn@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 Apr 2015 09:51:21 +0000

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

Other related posts: