CODEWITHSUNDEEP
javadatabasetdengine
superman
superman

Reputation: 1

No write permission when inserting data to TDengine

  1. I'm using JDBC to read/write data from/to TDengine database. Linux server. When executing insert statement, I got an error report.

Cause: java.sql.SQLException: TDengine ERROR (80000214): No write permission

I googled the error message, but got no help. How do I fix it?

Upvotes: 0

Views: 90

Answers (1)

cpvmrd
cpvmrd

Reputation: 41

According its document, you can grant read or write permissions.

If the version you use is below 3.0, you can try:

ALTER USER <user_name> PRIVILEGE <write|read>;

If the version you use is 3.0, you can try:

GRANT privileges ON priv_level TO user_name


privileges : {
    ALL
  | priv_type [, priv_type] ...
}
 
priv_type : {
    READ
  | WRITE
}
 
priv_level : {
    dbname.*
  | *.*
}

Upvotes: 0

Related Questions