[google-cloud-sql-discuss] JDBC: Apps Script and Google MySQL : Exception: You do not have permission to call Jdbc.getCloudSqlConnection

I get the following error when I attempt to run this function within google sheets: 

Exception: You do not have permission to call Jdbc.getCloudSqlConnection

any idea on how to fix this?

 

var connectionName = 'cosmic-tenure-310821:us-central1:propertydata'; 

var rootPwd = "password"; 

var user = "root"; var userPwd = 'password'; v

ar db = 'propertydata'; v

ar root = 'root'; v

ar instanceUrl = "jdbc:google:mysql://" + connectionName; var dbUrl = instanceUrl + "/" + db; f

unction createTable() 

 var conn = Jdbc.getCloudSqlConnection(dbUrl, user, userPwd); conn.createStatement().execute('CREATE TABLE myProperties(APN INT, APNObject MEDIUMBLOB)'); 

}

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/332613b2-266a-433f-a0da-78a1bbc90989n%40googlegroups.com.