title: How to GRANT privileges to a ROLE on an Oracle SCHEMA
body: <p>How i can grant some privileges to a <code>ROLE</code> on all tables of a SCHEMA?<br />
  I wrote this code, but in SQLDeveloper it gives an error.<br /></p>
  
  <pre><code>CREATE SCHEMA AUTHORIZATION alberto;
  
  CREATE TABLE Cucine (
    tipo varchar(1) primary key,
    descrizione varchar(200) not null
  );
  
  CREATE TABLE Quartieri (
    codice varchar(4) primary key,
    nome varchar(100) not null
  );
  
  CREATE TABLE Ristoranti (
    codice varchar(5) primary key,
    nome varchar(150) not null,
    indirizzo varchar(250),
    tipocucina varchar(1) references Cucine(tipo),
    codquart varchar(4) references Quartieri(codice)
  );
  
  CREATE TABLE CarteDiCredito (
    codcircuito varchar(4) primary key,
    nomecircuito varchar(100) not null
  );
  
  CREATE TABLE Convenzioni (
    circuito varchar(4) references CarteDiCredito(codcircuito),
    codristorante varchar(5) references Ristoranti(codice),
    primary key(circuito, codristorante)
  );
  
  CREATE ROLE turista;
  GRANT SELECT ON ENTE_TURISTICO.* TO turista;
  CREATE USER DBAEnte IDENTIFIED BY 12345;
  CREATE USER vinni IDENTIFIED BY mosh;
  GRANT dba TO DBAEnte;
  GRANT turista TO vinni;
  </code></pre>
  
  <p>What is wrong in this code?</p>