• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

taosdata / TDengine / #4936

23 Jan 2026 09:40AM UTC coverage: 66.746% (+0.04%) from 66.708%
#4936

push

travis-ci

web-flow
fix: case failuer caused by the modification of the error description (#34391)

204023 of 305671 relevant lines covered (66.75%)

124768167.97 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

84.44
/source/libs/parser/src/parAuthenticator.c
1
/*
2
 * Copyright (c) 2019 TAOS Data, Inc. <jhtao@taosdata.com>
3
 *
4
 * This program is free software: you can use, redistribute, and/or modify
5
 * it under the terms of the GNU Affero General Public License, version 3
6
 * or later ("AGPL"), as published by the Free Software Foundation.
7
 *
8
 * This program is distributed in the hope that it will be useful, but WITHOUT
9
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
10
 * FITNESS FOR A PARTICULAR PURPOSE.
11
 *
12
 * You should have received a copy of the GNU Affero General Public License
13
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
14
 */
15

16
#include "catalog.h"
17
#include "cmdnodes.h"
18
#include "parInt.h"
19

20
typedef struct SAuthCxt {
21
  SParseContext*   pParseCxt;
22
  SParseMetaCache* pMetaCache;
23
  int32_t          errCode;
24
} SAuthCxt;
25

26
typedef struct SSelectAuthCxt {
27
  SAuthCxt*    pAuthCxt;
28
  SSelectStmt* pSelect;
29
} SSelectAuthCxt;
30

31
typedef struct SAuthRewriteCxt {
32
  STableNode* pTarget;
33
} SAuthRewriteCxt;
34

35
static int32_t authQuery(SAuthCxt* pCxt, SNode* pStmt);
36

37
static int32_t setUserAuthInfo(SParseContext* pCxt, const char* pDbName, const char* pTabName, EPrivType privType,
1,599,664✔
38
                               EPrivObjType objType, bool isView, bool effective, SUserAuthInfo* pAuth) {
39
  if (effective) {
1,599,664✔
40
    snprintf(pAuth->user, sizeof(pAuth->user), "%s", pCxt->pEffectiveUser ? pCxt->pEffectiveUser : "");
×
41
    pAuth->userId = pCxt->effectiveUserId;  // TODO: assign the effective user id
×
42
  } else {
43
    snprintf(pAuth->user, sizeof(pAuth->user), "%s", pCxt->pUser);
1,599,664✔
44
    pAuth->userId = pCxt->userId;
1,599,664✔
45
  }
46

47
  if (NULL == pTabName) {
1,599,664✔
48
    if (pDbName) {
968,963✔
49
      int32_t code = tNameSetDbName(&pAuth->tbName, pCxt->acctId, pDbName, strlen(pDbName));
844,425✔
50
      if (TSDB_CODE_SUCCESS != code) return code;
844,425✔
51
    } else {
52
      pAuth->tbName.acctId = pCxt->acctId;
124,538✔
53
      pAuth->tbName.type = TSDB_SYS_NAME_T;
124,538✔
54
    }
55
  } else {
56
    toName(pCxt->acctId, pDbName, pTabName, &pAuth->tbName);
630,701✔
57
  }
58
  pAuth->privType = privType;
1,599,664✔
59
  pAuth->objType = objType;
1,599,664✔
60
  pAuth->isView = isView;
1,599,664✔
61
  return TSDB_CODE_SUCCESS;
1,599,664✔
62
}
63

64
static int32_t checkAuthByOwner(SAuthCxt* pCxt, SUserAuthInfo* pAuthInfo, SUserAuthRes* pAuthRes) {
1,599,664✔
65
  SParseContext*   pParseCxt = pCxt->pParseCxt;
1,599,664✔
66
  const SPrivInfo* pPrivInfo = privInfoGet(pAuthInfo->privType);
1,599,664✔
67
  if (NULL == pPrivInfo) {
1,599,664✔
68
    return TSDB_CODE_PAR_INTERNAL_ERROR;
×
69
  }
70
  int32_t code = 0;
1,599,664✔
71
  if (pPrivInfo->category == PRIV_CATEGORY_OBJECT || pAuthInfo->objType == PRIV_OBJ_DB) {
1,599,664✔
72
    SPrivInfo privInfoDup = *pPrivInfo;
1,086,050✔
73
    if (privInfoDup.objType <= 0) privInfoDup.objType = PRIV_OBJ_DB;
1,086,050✔
74
    switch (privInfoDup.objType) {
1,086,050✔
75
      case PRIV_OBJ_DB: {
844,425✔
76
        SDbCfgInfo dbCfgInfo = {0};
844,425✔
77
        char       dbFName[TSDB_DB_FNAME_LEN] = {0};
844,425✔
78
        (void)tNameGetFullDbName(&pAuthInfo->tbName, dbFName);
844,425✔
79
        code = getDbCfgFromCache(pCxt->pMetaCache, dbFName, &dbCfgInfo);
844,425✔
80
        if (TSDB_CODE_SUCCESS != code) {
844,425✔
81
          return code;
104,149✔
82
        }
83
        if (dbCfgInfo.ownerId == pAuthInfo->userId) {
740,276✔
84
          pAuthRes->pass[pAuthInfo->isView ? AUTH_RES_VIEW : AUTH_RES_BASIC] = true;
2,543✔
85
#if 0
86
          printf("%s:%d db %s owner match, pass\n", __func__, __LINE__, dbFName);
87
#endif
88
          return TSDB_CODE_SUCCESS;
2,543✔
89
        }
90
        break;
737,733✔
91
      }
92
      default:
241,625✔
93
        return TSDB_CODE_SUCCESS;
241,625✔
94
    }
95
  }
96
_exit:
513,614✔
97
  return TSDB_CODE_SUCCESS;
1,251,347✔
98
}
99

100
static int32_t checkAuthImpl(SAuthCxt* pCxt, const char* pDbName, const char* pTabName, EPrivType privType,
550,175,195✔
101
                             EPrivObjType objType, SNode** pCond, bool isView, bool effective) {
102
  SParseContext* pParseCxt = pCxt->pParseCxt;
550,175,195✔
103
  if (pParseCxt->isSuperUser) {
550,177,790✔
104
    return TSDB_CODE_SUCCESS;
548,581,677✔
105
  }
106

107
  AUTH_RES_TYPE auth_res_type = isView ? AUTH_RES_VIEW : AUTH_RES_BASIC;
1,599,651✔
108
  SUserAuthInfo authInfo = {0};
1,599,651✔
109
  int32_t code = setUserAuthInfo(pCxt->pParseCxt, pDbName, pTabName, privType, objType, isView, effective, &authInfo);
1,599,651✔
110
  if (TSDB_CODE_SUCCESS != code) return code;
1,599,664✔
111
  SUserAuthRes authRes = {0};
1,599,664✔
112
  if (NULL != pCxt->pMetaCache) {
1,599,664✔
113
    code = checkAuthByOwner(pCxt, &authInfo, &authRes);
1,599,664✔
114
    if (code == TSDB_CODE_SUCCESS && authRes.pass[auth_res_type]) {
1,599,664✔
115
      goto _exit;
2,543✔
116
    }
117
    code = getUserAuthFromCache(pCxt->pMetaCache, &authInfo, &authRes);
1,597,121✔
118
#ifdef TD_ENTERPRISE
119
    if (isView && TSDB_CODE_PAR_INTERNAL_ERROR == code) {
1,597,121✔
120
      authInfo.isView = false;
×
121
      code = getUserAuthFromCache(pCxt->pMetaCache, &authInfo, &authRes);
×
122
    }
123
#endif
124
  } else {
125
    SRequestConnInfo conn = {.pTrans = pParseCxt->pTransporter,
×
126
                             .requestId = pParseCxt->requestId,
×
127
                             .requestObjRefId = pParseCxt->requestRid,
×
128
                             .mgmtEps = pParseCxt->mgmtEpSet};
129
    code = catalogChkAuth(pParseCxt->pCatalog, &conn, &authInfo, &authRes);
×
130
  }
131
_exit:
1,599,664✔
132
  if (TSDB_CODE_SUCCESS == code && NULL != pCond) {
1,599,664✔
133
    *pCond = authRes.pCond[auth_res_type];
69,111✔
134
  }
135
  return TSDB_CODE_SUCCESS == code ? (authRes.pass[auth_res_type] ? TSDB_CODE_SUCCESS : TSDB_CODE_PAR_PERMISSION_DENIED)
1,598,680✔
136
                                   : code;
3,198,164✔
137
}
138

139
static int32_t checkAuth(SAuthCxt* pCxt, const char* pDbName, const char* pTabName, EPrivType privType,
550,174,188✔
140
                         EPrivObjType objType, SNode** pCond) {
141
#ifdef TD_ENTERPRISE
142
  return checkAuthImpl(pCxt, pDbName, pTabName, privType, objType, pCond, false, false);
550,174,188✔
143
#else
144
  return TSDB_CODE_SUCCESS;
145
#endif
146
}
147

148
static int32_t authSysPrivileges(SAuthCxt* pCxt, SNode* pStmt, EPrivType type) {
3,411,800✔
149
  return checkAuth(pCxt, NULL, NULL, type, 0, NULL);
3,411,800✔
150
}
151

152
static int32_t authObjPrivileges(SAuthCxt* pCxt, const char* pDbName, const char* pTabName, EPrivType privType,
366,360,402✔
153
                                 EPrivObjType objType) {
154
  if (!pDbName) {
366,360,402✔
155
    return TSDB_CODE_PAR_INTERNAL_ERROR;
×
156
  }
157

158
  return checkAuth(pCxt, pDbName, pTabName, privType, objType, NULL);
366,360,402✔
159
}
160

161
static int32_t checkEffectiveAuth(SAuthCxt* pCxt, const char* pDbName, const char* pTabName, EPrivType privType,
×
162
                                  EPrivObjType objType, SNode** pCond) {
163
  return checkAuthImpl(pCxt, pDbName, pTabName, privType, objType, NULL, false, true);
×
164
}
165

166
static int32_t checkViewAuth(SAuthCxt* pCxt, const char* pDbName, const char* pTabName, EPrivType privType,
7,319✔
167
                             EPrivObjType objType, SNode** pCond) {
168
  return checkAuthImpl(pCxt, pDbName, pTabName, privType, objType, pCond, true, false);
7,319✔
169
}
170

171
static int32_t checkViewEffectiveAuth(SAuthCxt* pCxt, const char* pDbName, const char* pTabName, EPrivType privType,
×
172
                                      EPrivObjType objType, SNode** pCond) {
173
  return checkAuthImpl(pCxt, pDbName, pTabName, privType, objType, pCond, true, true);
×
174
}
175

176
static EDealRes authSubquery(SAuthCxt* pCxt, SNode* pStmt) {
19,776,047✔
177
  return TSDB_CODE_SUCCESS == authQuery(pCxt, pStmt) ? DEAL_RES_CONTINUE : DEAL_RES_ERROR;
19,776,047✔
178
}
179

180
static int32_t mergeStableTagCond(SNode** pWhere, SNode* pTagCond) {
×
181
  SLogicConditionNode* pLogicCond = NULL;
×
182
  int32_t              code = nodesMakeNode(QUERY_NODE_LOGIC_CONDITION, (SNode**)&pLogicCond);
×
183
  if (NULL == pLogicCond) {
×
184
    return code;
×
185
  }
186
  pLogicCond->node.resType.type = TSDB_DATA_TYPE_BOOL;
×
187
  pLogicCond->node.resType.bytes = tDataTypes[TSDB_DATA_TYPE_BOOL].bytes;
×
188
  pLogicCond->condType = LOGIC_COND_TYPE_AND;
×
189
  code = nodesListMakeStrictAppend(&pLogicCond->pParameterList, pTagCond);
×
190
  if (TSDB_CODE_SUCCESS == code) {
×
191
    code = nodesListMakeAppend(&pLogicCond->pParameterList, *pWhere);
×
192
  }
193
  if (TSDB_CODE_SUCCESS == code) {
×
194
    *pWhere = (SNode*)pLogicCond;
×
195
  } else {
196
    nodesDestroyNode((SNode*)pLogicCond);
×
197
  }
198
  return code;
×
199
}
200

201
EDealRes rewriteAuthTable(SNode* pNode, void* pContext) {
5,553✔
202
  if (QUERY_NODE_COLUMN == nodeType(pNode)) {
5,553✔
203
    SColumnNode*     pCol = (SColumnNode*)pNode;
1,851✔
204
    SAuthRewriteCxt* pCxt = (SAuthRewriteCxt*)pContext;
1,851✔
205
    tstrncpy(pCol->tableName, pCxt->pTarget->tableName, TSDB_TABLE_NAME_LEN);
1,851✔
206
    tstrncpy(pCol->tableAlias, pCxt->pTarget->tableAlias, TSDB_TABLE_NAME_LEN);
1,851✔
207
  }
208

209
  return DEAL_RES_CONTINUE;
5,553✔
210
}
211

212
static int32_t rewriteAppendStableTagCond(SNode** pWhere, SNode* pTagCond, STableNode* pTable) {
1,851✔
213
  SNode*  pTagCondCopy = NULL;
1,851✔
214
  int32_t code = nodesCloneNode(pTagCond, &pTagCondCopy);
1,851✔
215
  if (NULL == pTagCondCopy) {
1,851✔
216
    return code;
×
217
  }
218

219
  SAuthRewriteCxt cxt = {.pTarget = pTable};
1,851✔
220
  nodesWalkExpr(pTagCondCopy, rewriteAuthTable, &cxt);
1,851✔
221

222
  if (NULL == *pWhere) {
1,851✔
223
    *pWhere = pTagCondCopy;
1,851✔
224
    return TSDB_CODE_SUCCESS;
1,851✔
225
  }
226

227
  if (QUERY_NODE_LOGIC_CONDITION == nodeType(*pWhere) &&
×
228
      LOGIC_COND_TYPE_AND == ((SLogicConditionNode*)*pWhere)->condType) {
×
229
    return nodesListStrictAppend(((SLogicConditionNode*)*pWhere)->pParameterList, pTagCondCopy);
×
230
  }
231

232
  return mergeStableTagCond(pWhere, pTagCondCopy);
×
233
}
234

235
static EDealRes authSelectImpl(SNode* pNode, void* pContext) {
1,527,088,620✔
236
  SSelectAuthCxt* pCxt = pContext;
1,527,088,620✔
237
  SAuthCxt*       pAuthCxt = pCxt->pAuthCxt;
1,527,088,620✔
238
  bool            isView = false;
1,527,089,128✔
239
  if (QUERY_NODE_REAL_TABLE == nodeType(pNode)) {
1,527,089,128✔
240
    SNode*      pTagCond = NULL;
134,806,376✔
241
    STableNode* pTable = (STableNode*)pNode;
134,804,992✔
242
    if ((pAuthCxt->pParseCxt->enableSysInfo == 0) && IS_INFORMATION_SCHEMA_DB(pTable->dbName) &&
134,804,992✔
243
        (strcmp(pTable->tableName, TSDB_INS_TABLE_VGROUPS) == 0)) {
18,856✔
244
      pAuthCxt->errCode = TSDB_CODE_PAR_PERMISSION_DENIED;
656✔
245
      return DEAL_RES_ERROR;
656✔
246
    }
247
    if (authObjPrivileges(pAuthCxt, pTable->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB) != TSDB_CODE_SUCCESS) {
134,805,128✔
248
      pAuthCxt->errCode = TSDB_CODE_PAR_PERMISSION_DENIED;
1,127✔
249
      return DEAL_RES_ERROR;
1,127✔
250
    }
251
#ifdef TD_ENTERPRISE
252
    SName name = {0};
134,802,673✔
253
    toName(pAuthCxt->pParseCxt->acctId, pTable->dbName, pTable->tableName, &name);
134,802,732✔
254
    STableMeta* pTableMeta = NULL;
134,804,170✔
255
    toName(pAuthCxt->pParseCxt->acctId, pTable->dbName, pTable->tableName, &name);
134,805,456✔
256
    int32_t code = getTargetMetaImpl(pAuthCxt->pParseCxt, pAuthCxt->pMetaCache, &name, &pTableMeta, true);
134,805,493✔
257
    if (TSDB_CODE_SUCCESS == code && TSDB_VIEW_TABLE == pTableMeta->tableType) {
134,803,865✔
258
      isView = true;
7,319✔
259
    }
260
    taosMemoryFree(pTableMeta);
134,803,255✔
261
#endif
262
    if (!isView) {
134,801,662✔
263
      pAuthCxt->errCode =
134,798,193✔
264
          checkAuth(pAuthCxt, pTable->dbName, pTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, &pTagCond);
134,794,343✔
265
      if (TSDB_CODE_SUCCESS != pAuthCxt->errCode && NULL != pAuthCxt->pParseCxt->pEffectiveUser) {
134,798,199✔
266
        pAuthCxt->errCode =
×
267
            checkEffectiveAuth(pAuthCxt, pTable->dbName, pTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, NULL);
×
268
      }
269
      if (TSDB_CODE_SUCCESS == pAuthCxt->errCode && NULL != pTagCond) {
134,795,853✔
270
        pAuthCxt->errCode = rewriteAppendStableTagCond(&pCxt->pSelect->pWhere, pTagCond, pTable);
1,851✔
271
      }
272
    } else {
273
      pAuthCxt->errCode =
7,319✔
274
          checkViewAuth(pAuthCxt, pTable->dbName, pTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, NULL);
7,319✔
275
      if (TSDB_CODE_SUCCESS != pAuthCxt->errCode && NULL != pAuthCxt->pParseCxt->pEffectiveUser) {
7,319✔
276
        pAuthCxt->errCode =
×
277
            checkViewEffectiveAuth(pAuthCxt, pTable->dbName, pTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, NULL);
×
278
      }
279
    }
280
    return TSDB_CODE_SUCCESS == pAuthCxt->errCode ? DEAL_RES_CONTINUE : DEAL_RES_ERROR;
134,804,929✔
281
  } else if (QUERY_NODE_TEMP_TABLE == nodeType(pNode)) {
1,392,284,194✔
282
    return authSubquery(pAuthCxt, ((STempTableNode*)pNode)->pSubquery);
19,776,484✔
283
  }
284
  return DEAL_RES_CONTINUE;
1,372,508,230✔
285
}
286

287
static int32_t authSelect(SAuthCxt* pCxt, SSelectStmt* pSelect) {
145,046,602✔
288
  SSelectAuthCxt cxt = {.pAuthCxt = pCxt, .pSelect = pSelect};
145,046,602✔
289
  nodesWalkSelectStmt(pSelect, SQL_CLAUSE_FROM, authSelectImpl, &cxt);
145,047,014✔
290
  return pCxt->errCode;
145,047,416✔
291
}
292

293
static int32_t authSetOperator(SAuthCxt* pCxt, SSetOperator* pSetOper) {
7,825,808✔
294
  int32_t code = authQuery(pCxt, pSetOper->pLeft);
7,825,808✔
295
  if (TSDB_CODE_SUCCESS == code) {
7,825,808✔
296
    code = authQuery(pCxt, pSetOper->pRight);
7,825,808✔
297
  }
298
  return code;
7,825,808✔
299
}
300

301
static int32_t authDropUser(SAuthCxt* pCxt, SDropUserStmt* pStmt) {
22,284✔
302
  // if (!pCxt->pParseCxt->isSuperUser || 0 == strcmp(pStmt->userName, TSDB_DEFAULT_USER)) {
303
  //   return TSDB_CODE_PAR_PERMISSION_DENIED;
304
  // }
305
  if (0 == strcmp(pStmt->userName, TSDB_DEFAULT_USER)) {
22,284✔
306
    return TSDB_CODE_PAR_PERMISSION_DENIED;
×
307
  }
308
  return authSysPrivileges(pCxt, (void*)pStmt, PRIV_USER_DROP);  // root has SYSDBA role with USER_DROP privilege
22,284✔
309
}
310

311
static int32_t authDelete(SAuthCxt* pCxt, SDeleteStmt* pDelete) {
1,683,457✔
312
  SNode*      pTagCond = NULL;
1,683,457✔
313
  STableNode* pTable = (STableNode*)pDelete->pFromTable;
1,683,457✔
314
  int32_t     code = checkAuth(pCxt, pTable->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL);
1,683,457✔
315
  if (TSDB_CODE_SUCCESS == code) {
1,683,457✔
316
    code = checkAuth(pCxt, pTable->dbName, pTable->tableName, PRIV_TBL_DELETE, PRIV_OBJ_TBL, &pTagCond);
1,683,457✔
317
  }
318
  if (TSDB_CODE_SUCCESS == code && NULL != pTagCond) {
1,683,457✔
319
    code = rewriteAppendStableTagCond(&pDelete->pWhere, pTagCond, pTable);
×
320
  }
321
  return code;
1,683,457✔
322
}
323

324
static int32_t authInsert(SAuthCxt* pCxt, SInsertStmt* pInsert) {
235,586✔
325
  SNode*      pTagCond = NULL;
235,586✔
326
  STableNode* pTable = (STableNode*)pInsert->pTable;
235,586✔
327
  // todo check tag condition for subtable
328
  int32_t code = checkAuth(pCxt, pTable->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL);
235,586✔
329
  if (TSDB_CODE_SUCCESS == code) {
235,586✔
330
    code = checkAuth(pCxt, pTable->dbName, pTable->tableName, PRIV_TBL_INSERT, PRIV_OBJ_TBL, &pTagCond);
235,586✔
331
  }
332
  return code;
235,586✔
333
}
334

335
static int32_t authShowTables(SAuthCxt* pCxt, SShowStmt* pStmt) {
495,759✔
336
  // return checkAuth(pCxt, ((SValueNode*)pStmt->pDbName)->literal, NULL, AUTH_TYPE_READ_OR_WRITE, NULL);
337
  // stb: more check in server, child table(TODO): more check when filter query result
338
  return authObjPrivileges(pCxt, ((SValueNode*)pStmt->pDbName)->literal, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
495,759✔
339
}
340

341
static int32_t authShowVtables(SAuthCxt* pCxt, SShowStmt* pStmt) { return authShowTables(pCxt, pStmt); }
57,219✔
342

343
static int32_t authShowUsage(SAuthCxt* pCxt, SShowStmt* pStmt) {
305✔
344
  return authObjPrivileges(pCxt, ((SValueNode*)pStmt->pDbName)->literal, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
305✔
345
}
346

347
static int32_t authShowCreateTable(SAuthCxt* pCxt, SShowCreateTableStmt* pStmt) {
79,164✔
348
  // SNode* pTagCond = NULL;
349
  // todo check tag condition for subtable
350
  // return checkAuth(pCxt, pStmt->dbName, pStmt->tableName, AUTH_TYPE_READ, &pTagCond);
351
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
79,164✔
352
  return authObjPrivileges(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_SHOW_CREATE, PRIV_OBJ_TBL);
75,720✔
353
}
354

355
static int32_t authShowCreateView(SAuthCxt* pCxt, SShowCreateViewStmt* pStmt) {
×
356
#ifndef TD_ENTERPRISE
357
  return TSDB_CODE_OPS_NOT_SUPPORT;
358
#else
359
  return TSDB_CODE_SUCCESS;
×
360
#endif
361
}
362

363
static int32_t authCreateTable(SAuthCxt* pCxt, SCreateTableStmt* pStmt) {
6,666,313✔
364
  // SNode* pTagCond = NULL;
365
  // todo check tag condition for subtable
366
  // return checkAuth(pCxt, pStmt->dbName, NULL, AUTH_TYPE_WRITE, &pTagCond);
367
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
6,666,313✔
368
  return authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB);
6,665,985✔
369
}
370

371
static int32_t authCreateVTable(SAuthCxt* pCxt, SCreateVTableStmt* pStmt) {
151,049✔
372
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
151,049✔
373
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB));
151,049✔
374
  SNode* pCol = NULL;
141,193✔
375
  FOREACH(pCol, pStmt->pCols) {
135,913,277✔
376
    SColumnDefNode* pColDef = (SColumnDefNode*)pCol;
135,779,476✔
377
    if (NULL == pColDef) {
135,779,476✔
378
      PAR_ERR_RET(TSDB_CODE_PAR_INVALID_COLUMN);
×
379
    }
380
    SColumnOptions* pOptions = (SColumnOptions*)pColDef->pOptions;
135,779,476✔
381
    if (pOptions && pOptions->hasRef) {
135,779,476✔
382
      PAR_ERR_RET(authObjPrivileges(pCxt, pOptions->refDb, pOptions->refTable, PRIV_TBL_SELECT, PRIV_OBJ_TBL));
84,726,230✔
383
    }
384
  }
385
  return TSDB_CODE_SUCCESS;
133,801✔
386
}
387

388
static int32_t authCreateVSubTable(SAuthCxt* pCxt, SCreateVSubTableStmt* pStmt) {
240,287✔
389
  int32_t    code = TSDB_CODE_SUCCESS;
240,287✔
390
  SNode*     pNode = NULL;
240,287✔
391
  SNodeList* pTmpList = pStmt->pSpecificColRefs ? pStmt->pSpecificColRefs : pStmt->pColRefs;
240,287✔
392
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
240,287✔
393
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB));
240,287✔
394
  if (NULL == pTmpList) {
230,431✔
395
    // no column reference
396
    return TSDB_CODE_SUCCESS;
13,023✔
397
  }
398

399
  FOREACH(pNode, pTmpList) {
51,913,750✔
400
    SColumnRefNode* pColRef = (SColumnRefNode*)pNode;
51,703,734✔
401
    if (NULL == pColRef) {
51,703,734✔
402
      PAR_ERR_RET(TSDB_CODE_PAR_INVALID_COLUMN);
×
403
    }
404
    PAR_ERR_RET(authObjPrivileges(pCxt, pColRef->refDbName, pColRef->refTableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL));
51,703,734✔
405
  }
406
  return code;
210,016✔
407
}
408

409
static int32_t authCreateStream(SAuthCxt* pCxt, SCreateStreamStmt* pStmt) {
283,721✔
410
  int32_t code = TSDB_CODE_SUCCESS;
283,721✔
411

412
  if (IS_SYS_DBNAME(pStmt->streamDbName)) {
283,721✔
413
    return TSDB_CODE_PAR_PERMISSION_DENIED;
×
414
  }
415
  if (IS_SYS_DBNAME(pStmt->targetDbName)) {
283,721✔
416
    return TSDB_CODE_PAR_PERMISSION_DENIED;
44✔
417
  }
418
  if (pStmt->pTrigger) {
283,677✔
419
    SStreamTriggerNode* pTrigger = (SStreamTriggerNode*)pStmt->pTrigger;
283,677✔
420
    STableNode*         pTriggerTable = (STableNode*)pTrigger->pTrigerTable;
283,677✔
421
    if (pTriggerTable) {
283,677✔
422
      if (IS_SYS_DBNAME(pTriggerTable->dbName)) return TSDB_CODE_PAR_PERMISSION_DENIED;
279,299✔
423
      PAR_ERR_RET(
279,255✔
424
          authObjPrivileges(pCxt, pTriggerTable->dbName, pTriggerTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL));
425
      PAR_ERR_RET(authObjPrivileges(pCxt, pTriggerTable->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
278,411✔
426
    }
427
  }
428

429
  PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->streamDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
282,789✔
430
  PAR_ERR_RET(
282,789✔
431
      authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->streamDbName, NULL, PRIV_STREAM_CREATE, PRIV_OBJ_DB));
432
  if (pStmt->targetDbName[0] != '\0') {
282,156✔
433
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->targetDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
279,091✔
434
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->targetDbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB));
279,091✔
435
  }
436
  if (pStmt->pQuery) {
281,945✔
437
    PAR_ERR_RET(authQuery(pCxt, pStmt->pQuery));
278,880✔
438
  }
439
  return code;
281,523✔
440
}
441

442
static int32_t authCreateTopic(SAuthCxt* pCxt, SCreateTopicStmt* pStmt) {
165,825✔
443
  int32_t code = TSDB_CODE_SUCCESS;
165,825✔
444

445
  if (IS_SYS_DBNAME(pStmt->subDbName)) {
165,825✔
446
    return TSDB_CODE_PAR_PERMISSION_DENIED;
×
447
  }
448
  if (NULL != pStmt->pQuery) {
165,825✔
449
    PAR_ERR_RET(authQuery(pCxt, pStmt->pQuery));
131,051✔
450
  }
451
  if (NULL != pStmt->pWhere) {
165,661✔
452
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateTopicStmt*)pStmt)->subDbName, ((SCreateTopicStmt*)pStmt)->subSTbName,
6,276✔
453
                                  PRIV_TBL_SELECT, PRIV_OBJ_TBL));
454
  }
455
  if (((SCreateTopicStmt*)pStmt)->subDbName[0] != '\0') {
165,661✔
456
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateTopicStmt*)pStmt)->subDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
34,774✔
457
  }
458

459
  return code;
165,661✔
460
}
461

462
static int32_t authCreateMultiTable(SAuthCxt* pCxt, SCreateMultiTablesStmt* pStmt) {
30,438,374✔
463
  int32_t code = TSDB_CODE_SUCCESS;
30,438,374✔
464
  SNode*  pNode = NULL;
30,438,374✔
465
  FOREACH(pNode, pStmt->pSubTables) {
66,964,754✔
466
    if (pNode->type == QUERY_NODE_CREATE_SUBTABLE_CLAUSE) {
36,520,085✔
467
      SCreateSubTableClause* pClause = (SCreateSubTableClause*)pNode;
36,520,937✔
468
      code = authObjPrivileges(pCxt, pClause->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
36,520,937✔
469
      if (TSDB_CODE_SUCCESS != code) {
36,520,877✔
470
        break;
164✔
471
      }
472
      code = authObjPrivileges(pCxt, pClause->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB);
36,520,713✔
473
      if (TSDB_CODE_SUCCESS != code) {
36,526,334✔
474
        break;
×
475
      }
476
    } else {
477
      SCreateSubTableFromFileClause* pClause = (SCreateSubTableFromFileClause*)pNode;
×
478
      code = authObjPrivileges(pCxt, pClause->useDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
×
479
      if (TSDB_CODE_SUCCESS != code) {
×
480
        break;
×
481
      }
482
      code = authObjPrivileges(pCxt, pClause->useDbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB);
×
483
      if (TSDB_CODE_SUCCESS != code) {
46✔
484
        break;
×
485
      }
486
    }
487
  }
488
  return code;
30,443,402✔
489
}
490

491
static int32_t authDropTable(SAuthCxt* pCxt, SDropTableStmt* pStmt) {
2,019,947✔
492
  int32_t code = TSDB_CODE_SUCCESS;
2,019,947✔
493
  if (pStmt->withOpt && !pCxt->pParseCxt->isSuperUser) {
2,019,947✔
494
    return TSDB_CODE_PAR_PERMISSION_DENIED;
258✔
495
  }
496
  SNode* pNode = NULL;
2,019,689✔
497
  FOREACH(pNode, pStmt->pTables) {
4,152,327✔
498
    SDropTableClause* pClause = (SDropTableClause*)pNode;
2,132,638✔
499
    PAR_ERR_RET(checkAuth(pCxt, pClause->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
2,132,638✔
500

501
    if (!pStmt->withOpt) {
2,132,638✔
502
      // for child table, check privileges of its super table later
503
      if (checkAuth(pCxt, pClause->dbName, pClause->tableName, PRIV_CM_DROP, PRIV_OBJ_TBL, NULL)) {
1,992,220✔
504
        code = TSDB_CODE_PAR_PERMISSION_DENIED;
×
505
        break;
×
506
      }
507
    }
508
  }
509

510
  return code;
2,019,689✔
511
}
512

513
static int32_t authDropStable(SAuthCxt* pCxt, SDropSuperTableStmt* pStmt) {
79,792✔
514
  if (pStmt->withOpt && !pCxt->pParseCxt->isSuperUser) {
79,792✔
515
    return TSDB_CODE_PAR_PERMISSION_DENIED;
129✔
516
  }
517
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
79,663✔
518
  if (!pStmt->withOpt) {
79,663✔
519
    PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_DROP, PRIV_OBJ_TBL, NULL));
28,294✔
520
  }
521
  return 0;
79,663✔
522
}
523

524
static int32_t authDropVtable(SAuthCxt* pCxt, SDropVirtualTableStmt* pStmt) {
69,795✔
525
  if (pStmt->withOpt && !pCxt->pParseCxt->isSuperUser) {
69,795✔
526
    return TSDB_CODE_PAR_PERMISSION_DENIED;
×
527
  }
528
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
69,795✔
529
  if (!pStmt->withOpt) {
69,795✔
530
    PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_DROP, PRIV_OBJ_TBL, NULL));
69,795✔
531
  }
532
  return 0;
59,907✔
533
}
534

535
static int32_t authAlterTable(SAuthCxt* pCxt, SAlterTableStmt* pStmt) {
18,193,215✔
536
  SNode* pTagCond = NULL;
18,193,215✔
537
  // todo check tag condition for subtable
538
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
18,193,215✔
539
  return checkAuth(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_ALTER, PRIV_OBJ_TBL, NULL);
18,192,273✔
540
}
541

542
static int32_t authAlterVTable(SAuthCxt* pCxt, SAlterTableStmt* pStmt) {
367,426✔
543
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
367,426✔
544
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_ALTER, PRIV_OBJ_TBL, NULL));
367,426✔
545
  if (pStmt->alterType == TSDB_ALTER_TABLE_ADD_COLUMN_WITH_COLUMN_REF ||
313,042✔
546
      pStmt->alterType == TSDB_ALTER_TABLE_ALTER_COLUMN_REF) {
285,232✔
547
    PAR_ERR_RET(checkAuth(pCxt, pStmt->refDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
120,409✔
548
    PAR_ERR_RET(checkAuth(pCxt, pStmt->refDbName, pStmt->refTableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, NULL));
120,409✔
549
  }
550
  PAR_RET(TSDB_CODE_SUCCESS);
293,266✔
551
}
552

553
static int32_t authCreateView(SAuthCxt* pCxt, SCreateViewStmt* pStmt) {
18,522✔
554
#ifndef TD_ENTERPRISE
555
  return TSDB_CODE_OPS_NOT_SUPPORT;
556
#else
557
  int32_t code = checkAuth(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL);
18,522✔
558
  if (TSDB_CODE_SUCCESS == code) {
18,522✔
559
    code = checkAuth(pCxt, pStmt->dbName, NULL, PRIV_VIEW_CREATE, PRIV_OBJ_DB, NULL);
18,522✔
560
  }
561
  if (TSDB_CODE_SUCCESS == code) {
18,522✔
562
    code = authQuery(pCxt, pStmt->pQuery);
18,522✔
563
  }
564
  return code;
18,522✔
565
#endif
566
}
567

568
static int32_t authDropView(SAuthCxt* pCxt, SDropViewStmt* pStmt) {
×
569
#ifndef TD_ENTERPRISE
570
  return TSDB_CODE_OPS_NOT_SUPPORT;
571
#else
572
  int32_t code = checkAuth(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL);
×
573
  if (TSDB_CODE_SUCCESS == code) {
×
574
    code = checkViewAuth(pCxt, pStmt->dbName, pStmt->viewName, PRIV_CM_DROP, PRIV_OBJ_VIEW, NULL);
×
575
  }
576
  if (code == 0) {
×
577
    pStmt->hasPrivilege = true;
×
578
  } else {
579
    code = 0;  // check owner in parTranslater
×
580
  }
581
  return code;
×
582
#endif
583
}
584

585
static int32_t authCreateIndex(SAuthCxt* pCxt, SCreateIndexStmt* pStmt) {
11,609✔
586
  int32_t code = authObjPrivileges(pCxt, ((SCreateIndexStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
11,609✔
587

588
  if (TSDB_CODE_SUCCESS == code) {
11,609✔
589
    code = authObjPrivileges(pCxt, ((SCreateIndexStmt*)pStmt)->dbName, ((SCreateIndexStmt*)pStmt)->tableName,
11,609✔
590
                             PRIV_TBL_SELECT, PRIV_OBJ_TBL);
591
  }
592

593
  if (TSDB_CODE_SUCCESS == code) {
11,609✔
594
    code = authObjPrivileges(pCxt, ((SCreateIndexStmt*)pStmt)->dbName, ((SCreateIndexStmt*)pStmt)->tableName,
11,609✔
595
                             PRIV_IDX_CREATE, PRIV_OBJ_TBL);
596
  }
597

598
  return code;
11,609✔
599
}
600

601
static int32_t authDropIndex(SAuthCxt* pCxt, SDropIndexStmt* pStmt) {
3,243✔
602
  int32_t code = authObjPrivileges(pCxt, ((SDropIndexStmt*)pStmt)->indexDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
3,243✔
603
  if (TSDB_CODE_SUCCESS == code) {
3,243✔
604
    code = authObjPrivileges(pCxt, ((SDropIndexStmt*)pStmt)->indexDbName, ((SDropIndexStmt*)pStmt)->indexName,
3,243✔
605
                             PRIV_CM_DROP, PRIV_OBJ_IDX);
606
  }
607
  return code;
3,243✔
608
}
609

610
static int32_t authShowIndexes(SAuthCxt* pCxt, SShowStmt* pStmt) { return authShowTables(pCxt, pStmt); }
4,276✔
611

612
static int32_t authCreateTsma(SAuthCxt* pCxt, SCreateTSMAStmt* pStmt) {
787✔
613
  int32_t code = authObjPrivileges(pCxt, ((SCreateTSMAStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
787✔
614
  if (TSDB_CODE_SUCCESS == code) {
787✔
615
    code = authObjPrivileges(pCxt, ((SCreateTSMAStmt*)pStmt)->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB);
787✔
616
  }
617
  if (!pStmt->pOptions->recursiveTsma) {
787✔
618
    if (TSDB_CODE_SUCCESS == code) {
787✔
619
      code = authObjPrivileges(pCxt, ((SCreateTSMAStmt*)pStmt)->dbName, ((SCreateTSMAStmt*)pStmt)->tableName,
787✔
620
                               PRIV_TBL_SELECT, PRIV_OBJ_TBL);
621
    }
622

623
    if (TSDB_CODE_SUCCESS == code) {
787✔
624
      code = authObjPrivileges(pCxt, ((SCreateTSMAStmt*)pStmt)->dbName, NULL,
787✔
625
                               PRIV_STREAM_CREATE, PRIV_OBJ_DB);
626
    }
627
    if (TSDB_CODE_SUCCESS == code) {
787✔
628
      code = authObjPrivileges(pCxt, ((SCreateTSMAStmt*)pStmt)->dbName, ((SCreateTSMAStmt*)pStmt)->tableName,
787✔
629
                               PRIV_TSMA_CREATE, PRIV_OBJ_TBL);
630
    }
631
  }
632

633
  return code;
787✔
634
}
635

636
static int32_t authDropTsma(SAuthCxt* pCxt, SDropTSMAStmt* pStmt) {
×
637
  int32_t code = authObjPrivileges(pCxt, ((SDropTSMAStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
×
638
  if (TSDB_CODE_SUCCESS == code) {
×
639
    code = authObjPrivileges(pCxt, ((SDropTSMAStmt*)pStmt)->dbName, ((SDropTSMAStmt*)pStmt)->tsmaName, PRIV_CM_DROP,
×
640
                             PRIV_OBJ_TSMA);
641
  }
642
  return code;
×
643
}
644

645
static int32_t authCreateRsma(SAuthCxt* pCxt, SCreateRsmaStmt* pStmt) {
109,515✔
646
  int32_t code = authObjPrivileges(pCxt, ((SCreateRsmaStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
109,515✔
647
  if (TSDB_CODE_SUCCESS == code) {
109,515✔
648
    code = authObjPrivileges(pCxt, ((SCreateRsmaStmt*)pStmt)->dbName, ((SCreateRsmaStmt*)pStmt)->tableName,
109,515✔
649
                             PRIV_TBL_SELECT, PRIV_OBJ_TBL);
650
  }
651
  if (TSDB_CODE_SUCCESS == code) {
109,515✔
652
    code = authObjPrivileges(pCxt, ((SCreateRsmaStmt*)pStmt)->dbName, ((SCreateRsmaStmt*)pStmt)->tableName,
109,515✔
653
                             PRIV_TBL_INSERT, PRIV_OBJ_TBL);
654
  }
655
  if (TSDB_CODE_SUCCESS == code) {
109,515✔
656
    code = authObjPrivileges(pCxt, ((SCreateRsmaStmt*)pStmt)->dbName, ((SCreateRsmaStmt*)pStmt)->tableName,
109,515✔
657
                             PRIV_RSMA_CREATE, PRIV_OBJ_TBL);
658
  }
659
  return code;
109,515✔
660
}
661

662
static int32_t authDropRsma(SAuthCxt* pCxt, SDropRsmaStmt* pStmt) {
2,205✔
663
  int32_t code = authObjPrivileges(pCxt, ((SDropRsmaStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
2,205✔
664
  if (TSDB_CODE_SUCCESS == code) {
2,205✔
665
    code = authObjPrivileges(pCxt, ((SDropRsmaStmt*)pStmt)->dbName, ((SDropRsmaStmt*)pStmt)->rsmaName, PRIV_CM_DROP,
2,205✔
666
                             PRIV_OBJ_RSMA);
667
  }
668
  return code;
2,205✔
669
}
670

671
static int32_t authShowCreateRsma(SAuthCxt* pCxt, SShowCreateRsmaStmt* pStmt) {
2,205✔
672
  int32_t code = authObjPrivileges(pCxt, ((SShowCreateRsmaStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
2,205✔
673
  if (TSDB_CODE_SUCCESS == code) {
2,205✔
674
    code = authObjPrivileges(pCxt, ((SShowCreateRsmaStmt*)pStmt)->dbName, ((SShowCreateRsmaStmt*)pStmt)->rsmaName,
2,205✔
675
                             PRIV_CM_SHOW_CREATE, PRIV_OBJ_RSMA);
676
  }
677
  if (code == 0) pStmt->hasPrivilege = true;
2,205✔
678
  return 0;  // return 0 and check owner later in translateShowCreateRsma since rsma ctgCatalog not available yet
2,205✔
679
}
680

681
static int32_t authGrant(SAuthCxt* pCxt, SGrantStmt* pStmt) {
566,524✔
682
  if (pStmt->optrType == TSDB_ALTER_ROLE_ROLE) {
566,524✔
683
    if (IS_SYS_PREFIX(pStmt->roleName)) {
2,254✔
684
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSDBA) == 0) {
2,096✔
685
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_SYSDBA);
158✔
686
      }
687
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSSEC) == 0) {
1,938✔
688
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_SYSSEC);
158✔
689
      }
690
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSAUDIT) == 0) {
1,780✔
691
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_SYSAUDIT);
158✔
692
      }
693
    }
694
  }
695
  return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_PRIVILEGE);
566,050✔
696
}
697

698
static int32_t authRevoke(SAuthCxt* pCxt, SRevokeStmt* pStmt) {
408,184✔
699
  if (pStmt->optrType == TSDB_ALTER_ROLE_ROLE) {
408,184✔
700
    if (IS_SYS_PREFIX(pStmt->roleName)) {
1,306✔
701
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSDBA) == 0) {
1,306✔
702
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_REVOKE_SYSDBA);
×
703
      }
704
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSSEC) == 0) {
1,306✔
705
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_REVOKE_SYSSEC);
×
706
      }
707
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSAUDIT) == 0) {
1,306✔
708
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_REVOKE_SYSAUDIT);
×
709
      }
710
    }
711
  }
712
  return authSysPrivileges(pCxt, (void*)pStmt, PRIV_REVOKE_PRIVILEGE);
408,184✔
713
}
714

715
static int32_t authQuery(SAuthCxt* pCxt, SNode* pStmt) {
282,586,421✔
716
  int32_t code = TSDB_CODE_SUCCESS;
282,586,421✔
717
#ifdef TD_ENTERPRISE
718
  switch (nodeType(pStmt)) {
282,586,421✔
719
    case QUERY_NODE_SET_OPERATOR:
7,825,808✔
720
      return authSetOperator(pCxt, (SSetOperator*)pStmt);
7,825,808✔
721
    case QUERY_NODE_SELECT_STMT:
145,044,607✔
722
      return authSelect(pCxt, (SSelectStmt*)pStmt);
145,044,607✔
723
    case QUERY_NODE_CREATE_ROLE_STMT:
158✔
724
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_CREATE);
158✔
725
    case QUERY_NODE_DROP_ROLE_STMT:
×
726
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_DROP);
×
727
    case QUERY_NODE_CREATE_USER_STMT:
58,486✔
728
      return authSysPrivileges(pCxt, pStmt, PRIV_USER_CREATE);
58,486✔
729
    case QUERY_NODE_DROP_USER_STMT:
22,284✔
730
      return authDropUser(pCxt, (SDropUserStmt*)pStmt);
22,284✔
731
    case QUERY_NODE_DELETE_STMT:
1,683,457✔
732
      return authDelete(pCxt, (SDeleteStmt*)pStmt);
1,683,457✔
733
    case QUERY_NODE_INSERT_STMT:
235,586✔
734
      return authInsert(pCxt, (SInsertStmt*)pStmt);
235,586✔
735
    case QUERY_NODE_CREATE_TABLE_STMT:
6,666,313✔
736
      return authCreateTable(pCxt, (SCreateTableStmt*)pStmt);
6,666,313✔
737
    case QUERY_NODE_CREATE_VIRTUAL_TABLE_STMT:
151,049✔
738
      return authCreateVTable(pCxt, (SCreateVTableStmt*)pStmt);
151,049✔
739
    case QUERY_NODE_CREATE_VIRTUAL_SUBTABLE_STMT:
240,287✔
740
      return authCreateVSubTable(pCxt, (SCreateVSubTableStmt*)pStmt);
240,287✔
741
    case QUERY_NODE_CREATE_MULTI_TABLES_STMT:
30,438,373✔
742
      return authCreateMultiTable(pCxt, (SCreateMultiTablesStmt*)pStmt);
30,438,373✔
743
    case QUERY_NODE_CREATE_STREAM_STMT:
283,721✔
744
      return authCreateStream(pCxt, (SCreateStreamStmt*)pStmt);
283,721✔
745
    case QUERY_NODE_CREATE_TOPIC_STMT:
165,825✔
746
      return authCreateTopic(pCxt, (SCreateTopicStmt*)pStmt);
165,825✔
747
    case QUERY_NODE_DROP_TABLE_STMT:
2,019,947✔
748
      return authDropTable(pCxt, (SDropTableStmt*)pStmt);
2,019,947✔
749
    case QUERY_NODE_DROP_SUPER_TABLE_STMT:
79,792✔
750
      return authDropStable(pCxt, (SDropSuperTableStmt*)pStmt);
79,792✔
751
    case QUERY_NODE_DROP_VIRTUAL_TABLE_STMT:
69,795✔
752
      return authDropVtable(pCxt, (SDropVirtualTableStmt*)pStmt);
69,795✔
753
    case QUERY_NODE_ALTER_TABLE_STMT:
18,193,215✔
754
    case QUERY_NODE_ALTER_SUPER_TABLE_STMT:
755
      return authAlterTable(pCxt, (SAlterTableStmt*)pStmt);
18,193,215✔
756
    case QUERY_NODE_ALTER_VIRTUAL_TABLE_STMT:
367,426✔
757
      return authAlterVTable(pCxt, (SAlterTableStmt*)pStmt);
367,426✔
758
    case QUERY_NODE_SHOW_MODULES_STMT:
111,405✔
759
    case QUERY_NODE_SHOW_BACKUP_NODES_STMT:
760
    case QUERY_NODE_SHOW_CLUSTER_STMT:
761
    case QUERY_NODE_SHOW_DB_ALIVE_STMT:
762
    // case QUERY_NODE_SHOW_CLUSTER_ALIVE_STMT:
763
    case QUERY_NODE_SHOW_CREATE_DATABASE_STMT:
764
    case QUERY_NODE_SHOW_TABLE_DISTRIBUTED_STMT:  // TODO: check in mnode
765
    case QUERY_NODE_SHOW_DNODE_VARIABLES_STMT:
766
    case QUERY_NODE_SHOW_SCORES_STMT:
767
    case QUERY_NODE_SHOW_ARBGROUPS_STMT:
768
    case QUERY_NODE_SHOW_ENCRYPTIONS_STMT:
769
    case QUERY_NODE_SHOW_MOUNTS_STMT:
770
    case QUERY_NODE_SHOW_ENCRYPT_ALGORITHMS_STMT:
771
    case QUERY_NODE_SHOW_ENCRYPT_STATUS_STMT:
772
      return !pCxt->pParseCxt->enableSysInfo ? TSDB_CODE_PAR_PERMISSION_DENIED : TSDB_CODE_SUCCESS;
111,405✔
773
    case QUERY_NODE_SHOW_USERS_STMT:
119,852✔
774
    case QUERY_NODE_SHOW_USERS_FULL_STMT:
775
      return authSysPrivileges(pCxt, pStmt, PRIV_USER_SHOW);
119,852✔
776
    case QUERY_NODE_SHOW_ROLES_STMT:
158✔
777
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_SHOW);
158✔
778
    case QUERY_NODE_SHOW_USER_PRIVILEGES_STMT:
3,706✔
779
    case QUERY_NODE_SHOW_ROLE_PRIVILEGES_STMT:
780
    case QUERY_NODE_SHOW_ROLE_COL_PRIVILEGES_STMT:
781
      return authSysPrivileges(pCxt, pStmt, PRIV_SHOW_PRIVILEGES);
3,706✔
782
    case QUERY_NODE_SHOW_DNODES_STMT:
419,042✔
783
    case QUERY_NODE_SHOW_MNODES_STMT:
784
    case QUERY_NODE_SHOW_QNODES_STMT:
785
    case QUERY_NODE_SHOW_SNODES_STMT:
786
    case QUERY_NODE_SHOW_BNODES_STMT:
787
    case QUERY_NODE_SHOW_ANODES_STMT:
788
    case QUERY_NODE_SHOW_ANODES_FULL_STMT:
789
    case QUERY_NODE_SHOW_XNODES_STMT: // TODO: check auth for xnode resources
790
    case QUERY_NODE_SHOW_XNODE_TASKS_STMT:
791
    case QUERY_NODE_SHOW_XNODE_AGENTS_STMT:
792
    case QUERY_NODE_SHOW_XNODE_JOBS_STMT:
793
      return authSysPrivileges(pCxt, pStmt, PRIV_NODES_SHOW);
419,042✔
794
    case QUERY_NODE_SHOW_CLUSTER_MACHINES_STMT:
5,634✔
795
    case QUERY_NODE_SHOW_LICENCES_STMT:
796
    case QUERY_NODE_SHOW_GRANTS_FULL_STMT:
797
    case QUERY_NODE_SHOW_GRANTS_LOGS_STMT:
798
      return authSysPrivileges(pCxt, pStmt, PRIV_GRANTS_SHOW);
5,634✔
799
    case QUERY_NODE_SHOW_TABLES_STMT:
434,264✔
800
    case QUERY_NODE_SHOW_STABLES_STMT:
801
      return authShowTables(pCxt, (SShowStmt*)pStmt);
434,264✔
802
    case QUERY_NODE_SHOW_VTABLES_STMT:
57,219✔
803
      return authShowVtables(pCxt, (SShowStmt*)pStmt);
57,219✔
804
    case QUERY_NODE_SHOW_CREATE_TABLE_STMT:
79,164✔
805
    case QUERY_NODE_SHOW_CREATE_VTABLE_STMT:
806
    case QUERY_NODE_SHOW_CREATE_STABLE_STMT:
807
      return authShowCreateTable(pCxt, (SShowCreateTableStmt*)pStmt);
79,164✔
808
    case QUERY_NODE_SHOW_CREATE_VIEW_STMT:
×
809
      return authShowCreateView(pCxt, (SShowCreateViewStmt*)pStmt);
×
810
    case QUERY_NODE_CREATE_VIEW_STMT:
18,522✔
811
      return authCreateView(pCxt, (SCreateViewStmt*)pStmt);
18,522✔
812
    case QUERY_NODE_DROP_VIEW_STMT:
×
813
      return authDropView(pCxt, (SDropViewStmt*)pStmt);
×
814
    case QUERY_NODE_CREATE_INDEX_STMT:
11,609✔
815
      return authCreateIndex(pCxt, (SCreateIndexStmt*)pStmt);
11,609✔
816
    case QUERY_NODE_DROP_INDEX_STMT:
3,243✔
817
      return authDropIndex(pCxt, (SDropIndexStmt*)pStmt);
3,243✔
818
    case QUERY_NODE_SHOW_INDEXES_STMT:
4,276✔
819
      return authShowIndexes(pCxt, (SShowStmt*)pStmt);
4,276✔
820
    case QUERY_NODE_CREATE_TSMA_STMT:
787✔
821
      return authCreateTsma(pCxt, (SCreateTSMAStmt*)pStmt);
787✔
822
    case QUERY_NODE_DROP_TSMA_STMT:
×
823
      return authDropTsma(pCxt, (SDropTSMAStmt*)pStmt);
×
824
    case QUERY_NODE_CREATE_RSMA_STMT:
109,515✔
825
      return authCreateRsma(pCxt, (SCreateRsmaStmt*)pStmt);
109,515✔
826
    case QUERY_NODE_DROP_RSMA_STMT:
2,205✔
827
      return authDropRsma(pCxt, (SDropRsmaStmt*)pStmt);
2,205✔
828
    case QUERY_NODE_ALTER_RSMA_STMT:
19,845✔
829
      return authObjPrivileges(pCxt, ((SAlterRsmaStmt*)pStmt)->dbName, ((SAlterRsmaStmt*)pStmt)->rsmaName,
19,845✔
830
                               PRIV_CM_ALTER, PRIV_OBJ_RSMA);
831
    case QUERY_NODE_SHOW_CREATE_RSMA_STMT:
2,205✔
832
      return authShowCreateRsma(pCxt, (SShowCreateRsmaStmt*)pStmt);
2,205✔
833
    case QUERY_NODE_CREATE_DATABASE_STMT:
1,298,627✔
834
      return authSysPrivileges(pCxt, pStmt, PRIV_DB_CREATE);
1,298,627✔
835
    case QUERY_NODE_BALANCE_VGROUP_STMT:
11,243✔
836
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_BALANCE);
11,243✔
837
    case QUERY_NODE_BALANCE_VGROUP_LEADER_DATABASE_STMT:
2,807✔
838
    case QUERY_NODE_BALANCE_VGROUP_LEADER_STMT:
839
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_BALANCE_LEADER);
2,807✔
840
    case QUERY_NODE_MERGE_VGROUP_STMT:
×
841
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_MERGE);
×
842
    case QUERY_NODE_SPLIT_VGROUP_STMT:
20,230✔
843
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_SPLIT);
20,230✔
844
    case QUERY_NODE_REDISTRIBUTE_VGROUP_STMT:
43,803✔
845
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_REDISTRIBUTE);
43,803✔
846
    case QUERY_NODE_CREATE_FUNCTION_STMT:
32,109✔
847
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_CREATE);
32,109✔
848
    case QUERY_NODE_DROP_FUNCTION_STMT:
23,717✔
849
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_DROP);
23,717✔
850
    case QUERY_NODE_SHOW_FUNCTIONS_STMT:
25,179✔
851
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_SHOW);
25,179✔
852
    case QUERY_NODE_GRANT_STMT:
566,524✔
853
      return authGrant(pCxt, (SGrantStmt*)pStmt);
566,524✔
854
    case QUERY_NODE_REVOKE_STMT:
408,184✔
855
      return authRevoke(pCxt, (SRevokeStmt*)pStmt);
408,184✔
856
    case QUERY_NODE_CREATE_DNODE_STMT:
266,889✔
857
    case QUERY_NODE_CREATE_MNODE_STMT:
858
    case QUERY_NODE_CREATE_QNODE_STMT:
859
    case QUERY_NODE_CREATE_SNODE_STMT:
860
    case QUERY_NODE_CREATE_BNODE_STMT:
861
    case QUERY_NODE_CREATE_ANODE_STMT:
862
      return authSysPrivileges(pCxt, pStmt, PRIV_NODE_CREATE);
266,889✔
863
    case QUERY_NODE_DROP_DNODE_STMT:
83,168✔
864
    case QUERY_NODE_DROP_MNODE_STMT:
865
    case QUERY_NODE_DROP_QNODE_STMT:
866
    case QUERY_NODE_DROP_SNODE_STMT:
867
    case QUERY_NODE_DROP_BNODE_STMT:
868
    case QUERY_NODE_DROP_ANODE_STMT:
869
      return authSysPrivileges(pCxt, pStmt, PRIV_NODE_DROP);
83,168✔
870
    case QUERY_NODE_ALTER_DATABASE_STMT:
176,437✔
871
      return authObjPrivileges(pCxt, ((SAlterDatabaseStmt*)pStmt)->dbName, NULL, PRIV_CM_ALTER, PRIV_OBJ_DB);
176,437✔
872
    case QUERY_NODE_DROP_DATABASE_STMT:
1,072,709✔
873
      return authObjPrivileges(pCxt, ((SDropDatabaseStmt*)pStmt)->dbName, NULL, PRIV_CM_DROP, PRIV_OBJ_DB);
1,072,709✔
874
    case QUERY_NODE_USE_DATABASE_STMT:
2,035,004✔
875
      return authObjPrivileges(pCxt, ((SAlterDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
2,035,004✔
876
    case QUERY_NODE_FLUSH_DATABASE_STMT:
1,756,936✔
877
      return authObjPrivileges(pCxt, ((SFlushDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_FLUSH, PRIV_OBJ_DB);
1,756,936✔
878
    case QUERY_NODE_COMPACT_DATABASE_STMT:
26,560✔
879
      return authObjPrivileges(pCxt, ((SCompactDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_COMPACT, PRIV_OBJ_DB);
26,560✔
880
    case QUERY_NODE_TRIM_DATABASE_STMT:
8,023✔
881
      return authObjPrivileges(pCxt, ((STrimDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_TRIM, PRIV_OBJ_DB);
8,023✔
882
    case QUERY_NODE_ROLLUP_DATABASE_STMT:
9,555✔
883
      return authObjPrivileges(pCxt, ((SRollupDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_ROLLUP, PRIV_OBJ_DB);
9,555✔
884
    case QUERY_NODE_SCAN_DATABASE_STMT:
92✔
885
      return authObjPrivileges(pCxt, ((SScanDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_SCAN, PRIV_OBJ_DB);
92✔
886
    case QUERY_NODE_SSMIGRATE_DATABASE_STMT:
×
887
      return authObjPrivileges(pCxt, ((SSsMigrateDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_SSMIGRATE, PRIV_OBJ_DB);
×
888
    case QUERY_NODE_SHOW_USAGE_STMT:  // disk info
5,284✔
889
      return authShowUsage(pCxt, (SShowStmt*)pStmt);
5,284✔
890
      // check in mnode
891
    case QUERY_NODE_SHOW_VGROUPS_STMT:
609,617✔
892
    case QUERY_NODE_SHOW_VNODES_STMT:
893
    case QUERY_NODE_SHOW_COMPACTS_STMT:
894
    case QUERY_NODE_SHOW_RETENTIONS_STMT:
895
    case QUERY_NODE_SHOW_SCANS_STMT:
896
    case QUERY_NODE_SHOW_SSMIGRATES_STMT:
897
      return TSDB_CODE_SUCCESS;
609,617✔
898
    default:
59,156,152✔
899
      break;
59,156,152✔
900
  }
901
#endif
902
  return code;
59,156,152✔
903
}
904

905
int32_t authenticate(SParseContext* pParseCxt, SQuery* pQuery, SParseMetaCache* pMetaCache) {
246,730,162✔
906
  SAuthCxt cxt = {.pParseCxt = pParseCxt, .pMetaCache = pMetaCache, .errCode = TSDB_CODE_SUCCESS};
246,730,162✔
907
  return authQuery(&cxt, pQuery->pRoot);
246,733,880✔
908
}
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc