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

taosdata / TDengine / #4940

27 Jan 2026 10:23AM UTC coverage: 66.832% (-0.1%) from 66.931%
#4940

push

travis-ci

web-flow
fix: asan invalid write issue (#34400)

7 of 8 new or added lines in 2 files covered. (87.5%)

822 existing lines in 141 files now uncovered.

204293 of 305680 relevant lines covered (66.83%)

124534723.83 hits per line

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

84.26
/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,605,983✔
38
                               EPrivObjType objType, bool isView, bool effective, SUserAuthInfo* pAuth) {
39
  if (effective) {
1,605,983✔
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,605,983✔
44
    pAuth->userId = pCxt->userId;
1,605,983✔
45
  }
46

47
  if (NULL == pTabName) {
1,605,983✔
48
    if (pDbName) {
976,459✔
49
      int32_t code = tNameSetDbName(&pAuth->tbName, pCxt->acctId, pDbName, strlen(pDbName));
841,029✔
50
      if (TSDB_CODE_SUCCESS != code) return code;
841,029✔
51
    } else {
52
      pAuth->tbName.acctId = pCxt->acctId;
135,430✔
53
      pAuth->tbName.type = TSDB_SYS_NAME_T;
135,430✔
54
    }
55
  } else {
56
    toName(pCxt->acctId, pDbName, pTabName, &pAuth->tbName);
629,524✔
57
  }
58
  pAuth->privType = privType;
1,605,983✔
59
  pAuth->objType = objType;
1,605,983✔
60
  pAuth->isView = isView;
1,605,983✔
61
  return TSDB_CODE_SUCCESS;
1,605,983✔
62
}
63

64
static int32_t checkAuthByOwner(SAuthCxt* pCxt, SUserAuthInfo* pAuthInfo, SUserAuthRes* pAuthRes) {
1,605,983✔
65
  SParseContext*   pParseCxt = pCxt->pParseCxt;
1,605,983✔
66
  const SPrivInfo* pPrivInfo = privInfoGet(pAuthInfo->privType);
1,605,983✔
67
  if (NULL == pPrivInfo) {
1,605,983✔
68
    return TSDB_CODE_PAR_INTERNAL_ERROR;
×
69
  }
70
  int32_t code = 0;
1,605,983✔
71
  if (pPrivInfo->category == PRIV_CATEGORY_OBJECT || pAuthInfo->objType == PRIV_OBJ_DB) {
1,605,983✔
72
    SPrivInfo privInfoDup = *pPrivInfo;
1,082,375✔
73
    if (privInfoDup.objType <= 0) privInfoDup.objType = PRIV_OBJ_DB;
1,082,375✔
74
    switch (privInfoDup.objType) {
1,082,375✔
75
      case PRIV_OBJ_DB: {
841,029✔
76
        SDbCfgInfo dbCfgInfo = {0};
841,029✔
77
        char       dbFName[TSDB_DB_FNAME_LEN] = {0};
841,029✔
78
        (void)tNameGetFullDbName(&pAuthInfo->tbName, dbFName);
841,029✔
79
        code = getDbCfgFromCache(pCxt->pMetaCache, dbFName, &dbCfgInfo);
841,029✔
80
        if (TSDB_CODE_SUCCESS != code) {
841,029✔
81
          return code;
103,656✔
82
        }
83
        if (dbCfgInfo.ownerId == pAuthInfo->userId) {
737,373✔
84
          pAuthRes->pass[pAuthInfo->isView ? AUTH_RES_VIEW : AUTH_RES_BASIC] = true;
2,553✔
85
#if 0
86
          printf("%s:%d db %s owner match, pass\n", __func__, __LINE__, dbFName);
87
#endif
88
          return TSDB_CODE_SUCCESS;
2,553✔
89
        }
90
        break;
734,820✔
91
      }
92
      default:
241,346✔
93
        return TSDB_CODE_SUCCESS;
241,346✔
94
    }
95
  }
96
_exit:
523,608✔
97
  return TSDB_CODE_SUCCESS;
1,258,428✔
98
}
99

100
static int32_t checkAuthImpl(SAuthCxt* pCxt, const char* pDbName, const char* pTabName, EPrivType privType,
429,334,634✔
101
                             EPrivObjType objType, SNode** pCond, bool isView, bool effective) {
102
  SParseContext* pParseCxt = pCxt->pParseCxt;
429,334,634✔
103
  if (pParseCxt->isSuperUser) {
429,337,973✔
104
    return TSDB_CODE_SUCCESS;
427,738,255✔
105
  }
106

107
  AUTH_RES_TYPE auth_res_type = isView ? AUTH_RES_VIEW : AUTH_RES_BASIC;
1,605,983✔
108
  SUserAuthInfo authInfo = {0};
1,605,983✔
109
  int32_t code = setUserAuthInfo(pCxt->pParseCxt, pDbName, pTabName, privType, objType, isView, effective, &authInfo);
1,605,983✔
110
  if (TSDB_CODE_SUCCESS != code) return code;
1,605,983✔
111
  SUserAuthRes authRes = {0};
1,605,983✔
112
  if (NULL != pCxt->pMetaCache) {
1,605,983✔
113
    code = checkAuthByOwner(pCxt, &authInfo, &authRes);
1,605,983✔
114
    if (code == TSDB_CODE_SUCCESS && authRes.pass[auth_res_type]) {
1,605,983✔
115
      goto _exit;
2,553✔
116
    }
117
    code = getUserAuthFromCache(pCxt->pMetaCache, &authInfo, &authRes);
1,603,430✔
118
#ifdef TD_ENTERPRISE
119
    if (isView && TSDB_CODE_PAR_INTERNAL_ERROR == code) {
1,603,430✔
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,605,983✔
132
  if (TSDB_CODE_SUCCESS == code && NULL != pCond) {
1,605,983✔
133
    *pCond = authRes.pCond[auth_res_type];
69,112✔
134
  }
135
  return TSDB_CODE_SUCCESS == code ? (authRes.pass[auth_res_type] ? TSDB_CODE_SUCCESS : TSDB_CODE_PAR_PERMISSION_DENIED)
1,604,998✔
136
                                   : code;
3,210,811✔
137
}
138

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

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

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

158
  return checkAuth(pCxt, pDbName, pTabName, privType, objType, NULL);
237,762,079✔
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,366✔
167
                             EPrivObjType objType, SNode** pCond) {
168
  return checkAuthImpl(pCxt, pDbName, pTabName, privType, objType, pCond, true, false);
7,366✔
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) {
22,405,313✔
177
  return TSDB_CODE_SUCCESS == authQuery(pCxt, pStmt) ? DEAL_RES_CONTINUE : DEAL_RES_ERROR;
22,405,313✔
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,454✔
202
  if (QUERY_NODE_COLUMN == nodeType(pNode)) {
5,454✔
203
    SColumnNode*     pCol = (SColumnNode*)pNode;
1,818✔
204
    SAuthRewriteCxt* pCxt = (SAuthRewriteCxt*)pContext;
1,818✔
205
    tstrncpy(pCol->tableName, pCxt->pTarget->tableName, TSDB_TABLE_NAME_LEN);
1,818✔
206
    tstrncpy(pCol->tableAlias, pCxt->pTarget->tableAlias, TSDB_TABLE_NAME_LEN);
1,818✔
207
  }
208

209
  return DEAL_RES_CONTINUE;
5,454✔
210
}
211

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

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

222
  if (NULL == *pWhere) {
1,818✔
223
    *pWhere = pTagCondCopy;
1,818✔
224
    return TSDB_CODE_SUCCESS;
1,818✔
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,634,115,152✔
236
  SSelectAuthCxt* pCxt = pContext;
1,634,115,152✔
237
  SAuthCxt*       pAuthCxt = pCxt->pAuthCxt;
1,634,115,152✔
238
  bool            isView = false;
1,634,116,534✔
239
  if (QUERY_NODE_REAL_TABLE == nodeType(pNode)) {
1,634,116,534✔
240
    SNode*      pTagCond = NULL;
141,997,948✔
241
    STableNode* pTable = (STableNode*)pNode;
141,997,433✔
242
    if ((pAuthCxt->pParseCxt->enableSysInfo == 0) && IS_INFORMATION_SCHEMA_DB(pTable->dbName) &&
141,997,433✔
243
        (strcmp(pTable->tableName, TSDB_INS_TABLE_VGROUPS) == 0)) {
18,860✔
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) {
141,997,292✔
248
      pAuthCxt->errCode = TSDB_CODE_PAR_PERMISSION_DENIED;
1,134✔
249
      return DEAL_RES_ERROR;
1,134✔
250
    }
251
#ifdef TD_ENTERPRISE
252
    SName name = {0};
141,991,950✔
253
    toName(pAuthCxt->pParseCxt->acctId, pTable->dbName, pTable->tableName, &name);
141,992,881✔
254
    STableMeta* pTableMeta = NULL;
141,994,479✔
255
    toName(pAuthCxt->pParseCxt->acctId, pTable->dbName, pTable->tableName, &name);
141,995,303✔
256
    int32_t code = getTargetMetaImpl(pAuthCxt->pParseCxt, pAuthCxt->pMetaCache, &name, &pTableMeta, true);
141,996,161✔
257
    if (TSDB_CODE_SUCCESS == code && TSDB_VIEW_TABLE == pTableMeta->tableType) {
141,994,886✔
258
      isView = true;
7,366✔
259
    }
260
    taosMemoryFree(pTableMeta);
141,994,920✔
261
#endif
262
    if (!isView) {
141,993,986✔
263
      pAuthCxt->errCode =
141,988,364✔
264
          checkAuth(pAuthCxt, pTable->dbName, pTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, &pTagCond);
141,986,620✔
265
      if (TSDB_CODE_SUCCESS != pAuthCxt->errCode && NULL != pAuthCxt->pParseCxt->pEffectiveUser) {
141,988,808✔
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) {
141,988,000✔
270
        pAuthCxt->errCode = rewriteAppendStableTagCond(&pCxt->pSelect->pWhere, pTagCond, pTable);
1,818✔
271
      }
272
    } else {
273
      pAuthCxt->errCode =
7,366✔
274
          checkViewAuth(pAuthCxt, pTable->dbName, pTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, NULL);
7,366✔
275
      if (TSDB_CODE_SUCCESS != pAuthCxt->errCode && NULL != pAuthCxt->pParseCxt->pEffectiveUser) {
7,366✔
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;
141,994,797✔
281
  } else if (QUERY_NODE_TEMP_TABLE == nodeType(pNode)) {
1,492,128,318✔
282
    return authSubquery(pAuthCxt, ((STempTableNode*)pNode)->pSubquery);
22,405,385✔
283
  }
284
  return DEAL_RES_CONTINUE;
1,469,721,712✔
285
}
286

287
static int32_t authSelect(SAuthCxt* pCxt, SSelectStmt* pSelect) {
153,851,528✔
288
  SSelectAuthCxt cxt = {.pAuthCxt = pCxt, .pSelect = pSelect};
153,851,528✔
289
  nodesWalkSelectStmt(pSelect, SQL_CLAUSE_FROM, authSelectImpl, &cxt);
153,852,318✔
290
  return pCxt->errCode;
153,853,587✔
291
}
292

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

301
static int32_t authDropUser(SAuthCxt* pCxt, SDropUserStmt* pStmt) {
22,444✔
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,444✔
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,444✔
309
}
310

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

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

335
static int32_t authShowTables(SAuthCxt* pCxt, SShowStmt* pStmt) {
491,831✔
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);
491,831✔
339
}
340

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

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

347
static int32_t authShowCreateTable(SAuthCxt* pCxt, SShowCreateTableStmt* pStmt) {
80,903✔
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));
80,903✔
352
  return authObjPrivileges(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_SHOW_CREATE, PRIV_OBJ_TBL);
77,459✔
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) {
5,212,600✔
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));
5,212,600✔
368
  return authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB);
5,212,272✔
369
}
370

371
static int32_t authCreateVTable(SAuthCxt* pCxt, SCreateVTableStmt* pStmt) {
143,690✔
372
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
143,690✔
373
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB));
143,690✔
374
  SNode* pCol = NULL;
133,994✔
375
  FOREACH(pCol, pStmt->pCols) {
1,655,544✔
376
    SColumnDefNode* pColDef = (SColumnDefNode*)pCol;
1,528,822✔
377
    if (NULL == pColDef) {
1,528,822✔
378
      PAR_ERR_RET(TSDB_CODE_PAR_INVALID_COLUMN);
×
379
    }
380
    SColumnOptions* pOptions = (SColumnOptions*)pColDef->pOptions;
1,528,822✔
381
    if (pOptions && pOptions->hasRef) {
1,528,822✔
382
      PAR_ERR_RET(authObjPrivileges(pCxt, pOptions->refDb, pOptions->refTable, PRIV_TBL_SELECT, PRIV_OBJ_TBL));
820,964✔
383
    }
384
  }
385
  return TSDB_CODE_SUCCESS;
126,722✔
386
}
387

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

399
  FOREACH(pNode, pTmpList) {
1,528,825✔
400
    SColumnRefNode* pColRef = (SColumnRefNode*)pNode;
1,325,566✔
401
    if (NULL == pColRef) {
1,325,566✔
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));
1,325,566✔
405
  }
406
  return code;
203,259✔
407
}
408

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

412
  if (IS_SYS_DBNAME(pStmt->streamDbName)) {
289,866✔
413
    return TSDB_CODE_PAR_PERMISSION_DENIED;
×
414
  }
415
  if (IS_SYS_DBNAME(pStmt->targetDbName)) {
289,866✔
416
    return TSDB_CODE_PAR_PERMISSION_DENIED;
39✔
417
  }
418
  if (pStmt->pTrigger) {
289,827✔
419
    SStreamTriggerNode* pTrigger = (SStreamTriggerNode*)pStmt->pTrigger;
289,827✔
420
    STableNode*         pTriggerTable = (STableNode*)pTrigger->pTrigerTable;
289,827✔
421
    if (pTriggerTable) {
289,827✔
422
      if (IS_SYS_DBNAME(pTriggerTable->dbName)) return TSDB_CODE_PAR_PERMISSION_DENIED;
285,330✔
423
      PAR_ERR_RET(
285,291✔
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));
284,435✔
426
    }
427
  }
428

429
  PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->streamDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
288,932✔
430
  PAR_ERR_RET(
288,932✔
431
      authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->streamDbName, NULL, PRIV_STREAM_CREATE, PRIV_OBJ_DB));
432
  if (pStmt->targetDbName[0] != '\0') {
288,290✔
433
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->targetDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
285,131✔
434
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->targetDbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB));
285,131✔
435
  }
436
  if (pStmt->pQuery) {
288,076✔
437
    PAR_ERR_RET(authQuery(pCxt, pStmt->pQuery));
284,917✔
438
  }
439
  return code;
287,648✔
440
}
441

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

445
  if (IS_SYS_DBNAME(pStmt->subDbName)) {
168,514✔
446
    return TSDB_CODE_PAR_PERMISSION_DENIED;
×
447
  }
448
  if (NULL != pStmt->pQuery) {
168,514✔
449
    PAR_ERR_RET(authQuery(pCxt, pStmt->pQuery));
132,688✔
450
  }
451
  if (NULL != pStmt->pWhere) {
168,349✔
452
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateTopicStmt*)pStmt)->subDbName, ((SCreateTopicStmt*)pStmt)->subSTbName,
6,457✔
453
                                  PRIV_TBL_SELECT, PRIV_OBJ_TBL));
454
  }
455
  if (((SCreateTopicStmt*)pStmt)->subDbName[0] != '\0') {
168,349✔
456
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateTopicStmt*)pStmt)->subDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
35,826✔
457
  }
458

459
  return code;
168,349✔
460
}
461

462
static int32_t authCreateMultiTable(SAuthCxt* pCxt, SCreateMultiTablesStmt* pStmt) {
30,987,746✔
463
  int32_t code = TSDB_CODE_SUCCESS;
30,987,746✔
464
  SNode*  pNode = NULL;
30,987,746✔
465
  FOREACH(pNode, pStmt->pSubTables) {
68,189,882✔
466
    if (pNode->type == QUERY_NODE_CREATE_SUBTABLE_CLAUSE) {
37,199,338✔
467
      SCreateSubTableClause* pClause = (SCreateSubTableClause*)pNode;
37,199,638✔
468
      code = authObjPrivileges(pCxt, pClause->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
37,199,638✔
469
      if (TSDB_CODE_SUCCESS != code) {
37,193,097✔
470
        break;
164✔
471
      }
472
      code = authObjPrivileges(pCxt, pClause->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB);
37,192,933✔
473
      if (TSDB_CODE_SUCCESS != code) {
37,202,501✔
474
        break;
×
475
      }
476
    } else {
UNCOV
477
      SCreateSubTableFromFileClause* pClause = (SCreateSubTableFromFileClause*)pNode;
×
UNCOV
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);
×
UNCOV
483
      if (TSDB_CODE_SUCCESS != code) {
×
484
        break;
×
485
      }
486
    }
487
  }
488
  return code;
30,996,473✔
489
}
490

491
static int32_t authDropTable(SAuthCxt* pCxt, SDropTableStmt* pStmt) {
2,044,366✔
492
  int32_t code = TSDB_CODE_SUCCESS;
2,044,366✔
493
  if (pStmt->withOpt && !pCxt->pParseCxt->isSuperUser) {
2,044,366✔
494
    return TSDB_CODE_PAR_PERMISSION_DENIED;
258✔
495
  }
496
  SNode* pNode = NULL;
2,044,108✔
497
  FOREACH(pNode, pStmt->pTables) {
4,201,268✔
498
    SDropTableClause* pClause = (SDropTableClause*)pNode;
2,157,160✔
499
    PAR_ERR_RET(checkAuth(pCxt, pClause->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
2,157,160✔
500

501
    if (!pStmt->withOpt) {
2,157,160✔
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)) {
2,014,066✔
504
        code = TSDB_CODE_PAR_PERMISSION_DENIED;
×
505
        break;
×
506
      }
507
    }
508
  }
509

510
  return code;
2,044,108✔
511
}
512

513
static int32_t authDropStable(SAuthCxt* pCxt, SDropSuperTableStmt* pStmt) {
85,398✔
514
  if (pStmt->withOpt && !pCxt->pParseCxt->isSuperUser) {
85,398✔
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));
85,269✔
518
  if (!pStmt->withOpt) {
85,269✔
519
    PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_DROP, PRIV_OBJ_TBL, NULL));
31,050✔
520
  }
521
  return 0;
85,269✔
522
}
523

524
static int32_t authDropVtable(SAuthCxt* pCxt, SDropVirtualTableStmt* pStmt) {
69,215✔
525
  if (pStmt->withOpt && !pCxt->pParseCxt->isSuperUser) {
69,215✔
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,215✔
529
  if (!pStmt->withOpt) {
69,215✔
530
    PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_DROP, PRIV_OBJ_TBL, NULL));
69,215✔
531
  }
532
  return 0;
59,415✔
533
}
534

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

542
static int32_t authAlterVTable(SAuthCxt* pCxt, SAlterTableStmt* pStmt) {
364,369✔
543
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
364,369✔
544
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_ALTER, PRIV_OBJ_TBL, NULL));
364,369✔
545
  if (pStmt->alterType == TSDB_ALTER_TABLE_ADD_COLUMN_WITH_COLUMN_REF ||
310,249✔
546
      pStmt->alterType == TSDB_ALTER_TABLE_ALTER_COLUMN_REF) {
282,439✔
547
    PAR_ERR_RET(checkAuth(pCxt, pStmt->refDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
121,382✔
548
    PAR_ERR_RET(checkAuth(pCxt, pStmt->refDbName, pStmt->refTableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, NULL));
121,382✔
549
  }
550
  PAR_RET(TSDB_CODE_SUCCESS);
289,347✔
551
}
552

553
static int32_t authCreateView(SAuthCxt* pCxt, SCreateViewStmt* pStmt) {
18,782✔
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,782✔
558
  if (TSDB_CODE_SUCCESS == code) {
18,782✔
559
    code = checkAuth(pCxt, pStmt->dbName, NULL, PRIV_VIEW_CREATE, PRIV_OBJ_DB, NULL);
18,782✔
560
  }
561
  if (TSDB_CODE_SUCCESS == code) {
18,782✔
562
    code = authQuery(pCxt, pStmt->pQuery);
18,782✔
563
  }
564
  return code;
18,782✔
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,686✔
586
  int32_t code = authObjPrivileges(pCxt, ((SCreateIndexStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
11,686✔
587

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

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

598
  return code;
11,686✔
599
}
600

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

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

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

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

633
  return code;
836✔
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) {
560,491✔
682
  if (pStmt->optrType == TSDB_ALTER_ROLE_ROLE) {
560,491✔
683
    if (IS_SYS_PREFIX(pStmt->roleName)) {
2,247✔
684
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSDBA) == 0) {
2,090✔
685
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_SYSDBA);
157✔
686
      }
687
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSSEC) == 0) {
1,933✔
688
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_SYSSEC);
157✔
689
      }
690
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSAUDIT) == 0) {
1,776✔
691
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_SYSAUDIT);
157✔
692
      }
693
    }
694
  }
695
  return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_PRIVILEGE);
560,020✔
696
}
697

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

715
static int32_t authQuery(SAuthCxt* pCxt, SNode* pStmt) {
300,556,977✔
716
  int32_t code = TSDB_CODE_SUCCESS;
300,556,977✔
717
#ifdef TD_ENTERPRISE
718
  switch (nodeType(pStmt)) {
300,556,977✔
719
    case QUERY_NODE_SET_OPERATOR:
8,619,770✔
720
      return authSetOperator(pCxt, (SSetOperator*)pStmt);
8,619,770✔
721
    case QUERY_NODE_SELECT_STMT:
153,850,686✔
722
      return authSelect(pCxt, (SSelectStmt*)pStmt);
153,850,686✔
723
    case QUERY_NODE_CREATE_ROLE_STMT:
157✔
724
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_CREATE);
157✔
725
    case QUERY_NODE_DROP_ROLE_STMT:
×
726
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_DROP);
×
727
    case QUERY_NODE_CREATE_USER_STMT:
59,755✔
728
      return authSysPrivileges(pCxt, pStmt, PRIV_USER_CREATE);
59,755✔
729
    case QUERY_NODE_DROP_USER_STMT:
22,444✔
730
      return authDropUser(pCxt, (SDropUserStmt*)pStmt);
22,444✔
731
    case QUERY_NODE_DELETE_STMT:
1,729,673✔
732
      return authDelete(pCxt, (SDeleteStmt*)pStmt);
1,729,673✔
733
    case QUERY_NODE_INSERT_STMT:
205,491✔
734
      return authInsert(pCxt, (SInsertStmt*)pStmt);
205,491✔
735
    case QUERY_NODE_CREATE_TABLE_STMT:
5,212,600✔
736
      return authCreateTable(pCxt, (SCreateTableStmt*)pStmt);
5,212,600✔
737
    case QUERY_NODE_CREATE_VIRTUAL_TABLE_STMT:
143,690✔
738
      return authCreateVTable(pCxt, (SCreateVTableStmt*)pStmt);
143,690✔
739
    case QUERY_NODE_CREATE_VIRTUAL_SUBTABLE_STMT:
230,889✔
740
      return authCreateVSubTable(pCxt, (SCreateVSubTableStmt*)pStmt);
230,889✔
741
    case QUERY_NODE_CREATE_MULTI_TABLES_STMT:
30,987,279✔
742
      return authCreateMultiTable(pCxt, (SCreateMultiTablesStmt*)pStmt);
30,987,279✔
743
    case QUERY_NODE_CREATE_STREAM_STMT:
289,866✔
744
      return authCreateStream(pCxt, (SCreateStreamStmt*)pStmt);
289,866✔
745
    case QUERY_NODE_CREATE_TOPIC_STMT:
168,514✔
746
      return authCreateTopic(pCxt, (SCreateTopicStmt*)pStmt);
168,514✔
747
    case QUERY_NODE_DROP_TABLE_STMT:
2,044,366✔
748
      return authDropTable(pCxt, (SDropTableStmt*)pStmt);
2,044,366✔
749
    case QUERY_NODE_DROP_SUPER_TABLE_STMT:
85,398✔
750
      return authDropStable(pCxt, (SDropSuperTableStmt*)pStmt);
85,398✔
751
    case QUERY_NODE_DROP_VIRTUAL_TABLE_STMT:
69,215✔
752
      return authDropVtable(pCxt, (SDropVirtualTableStmt*)pStmt);
69,215✔
753
    case QUERY_NODE_ALTER_TABLE_STMT:
18,406,688✔
754
    case QUERY_NODE_ALTER_SUPER_TABLE_STMT:
755
      return authAlterTable(pCxt, (SAlterTableStmt*)pStmt);
18,406,688✔
756
    case QUERY_NODE_ALTER_VIRTUAL_TABLE_STMT:
364,369✔
757
      return authAlterVTable(pCxt, (SAlterTableStmt*)pStmt);
364,369✔
758
    case QUERY_NODE_SHOW_MODULES_STMT:
116,184✔
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;
116,184✔
773
    case QUERY_NODE_SHOW_USERS_STMT:
132,243✔
774
    case QUERY_NODE_SHOW_USERS_FULL_STMT:
775
      return authSysPrivileges(pCxt, pStmt, PRIV_USER_SHOW);
132,243✔
776
    case QUERY_NODE_SHOW_ROLES_STMT:
157✔
777
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_SHOW);
157✔
778
    case QUERY_NODE_SHOW_USER_PRIVILEGES_STMT:
3,707✔
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,707✔
782
    case QUERY_NODE_SHOW_DNODES_STMT:
427,860✔
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);
427,860✔
794
    case QUERY_NODE_SHOW_CLUSTER_MACHINES_STMT:
5,488✔
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,488✔
799
    case QUERY_NODE_SHOW_TABLES_STMT:
431,251✔
800
    case QUERY_NODE_SHOW_STABLES_STMT:
801
      return authShowTables(pCxt, (SShowStmt*)pStmt);
431,251✔
802
    case QUERY_NODE_SHOW_VTABLES_STMT:
56,268✔
803
      return authShowVtables(pCxt, (SShowStmt*)pStmt);
56,268✔
804
    case QUERY_NODE_SHOW_CREATE_TABLE_STMT:
80,903✔
805
    case QUERY_NODE_SHOW_CREATE_VTABLE_STMT:
806
    case QUERY_NODE_SHOW_CREATE_STABLE_STMT:
807
      return authShowCreateTable(pCxt, (SShowCreateTableStmt*)pStmt);
80,903✔
808
    case QUERY_NODE_SHOW_CREATE_VIEW_STMT:
×
809
      return authShowCreateView(pCxt, (SShowCreateViewStmt*)pStmt);
×
810
    case QUERY_NODE_CREATE_VIEW_STMT:
18,782✔
811
      return authCreateView(pCxt, (SCreateViewStmt*)pStmt);
18,782✔
812
    case QUERY_NODE_DROP_VIEW_STMT:
×
813
      return authDropView(pCxt, (SDropViewStmt*)pStmt);
×
814
    case QUERY_NODE_CREATE_INDEX_STMT:
11,686✔
815
      return authCreateIndex(pCxt, (SCreateIndexStmt*)pStmt);
11,686✔
816
    case QUERY_NODE_DROP_INDEX_STMT:
3,264✔
817
      return authDropIndex(pCxt, (SDropIndexStmt*)pStmt);
3,264✔
818
    case QUERY_NODE_SHOW_INDEXES_STMT:
4,312✔
819
      return authShowIndexes(pCxt, (SShowStmt*)pStmt);
4,312✔
820
    case QUERY_NODE_CREATE_TSMA_STMT:
836✔
821
      return authCreateTsma(pCxt, (SCreateTSMAStmt*)pStmt);
836✔
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,330,424✔
834
      return authSysPrivileges(pCxt, pStmt, PRIV_DB_CREATE);
1,330,424✔
835
    case QUERY_NODE_BALANCE_VGROUP_STMT:
11,245✔
836
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_BALANCE);
11,245✔
837
    case QUERY_NODE_BALANCE_VGROUP_LEADER_DATABASE_STMT:
2,212✔
838
    case QUERY_NODE_BALANCE_VGROUP_LEADER_STMT:
839
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_BALANCE_LEADER);
2,212✔
840
    case QUERY_NODE_MERGE_VGROUP_STMT:
×
841
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_MERGE);
×
842
    case QUERY_NODE_SPLIT_VGROUP_STMT:
17,524✔
843
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_SPLIT);
17,524✔
844
    case QUERY_NODE_REDISTRIBUTE_VGROUP_STMT:
45,315✔
845
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_REDISTRIBUTE);
45,315✔
846
    case QUERY_NODE_CREATE_FUNCTION_STMT:
31,782✔
847
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_CREATE);
31,782✔
848
    case QUERY_NODE_DROP_FUNCTION_STMT:
23,548✔
849
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_DROP);
23,548✔
850
    case QUERY_NODE_SHOW_FUNCTIONS_STMT:
25,027✔
851
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_SHOW);
25,027✔
852
    case QUERY_NODE_GRANT_STMT:
560,491✔
853
      return authGrant(pCxt, (SGrantStmt*)pStmt);
560,491✔
854
    case QUERY_NODE_REVOKE_STMT:
403,432✔
855
      return authRevoke(pCxt, (SRevokeStmt*)pStmt);
403,432✔
856
    case QUERY_NODE_CREATE_DNODE_STMT:
271,900✔
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);
271,900✔
863
    case QUERY_NODE_DROP_DNODE_STMT:
88,552✔
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);
88,552✔
870
    case QUERY_NODE_ALTER_DATABASE_STMT:
180,360✔
871
      return authObjPrivileges(pCxt, ((SAlterDatabaseStmt*)pStmt)->dbName, NULL, PRIV_CM_ALTER, PRIV_OBJ_DB);
180,360✔
872
    case QUERY_NODE_DROP_DATABASE_STMT:
1,097,669✔
873
      return authObjPrivileges(pCxt, ((SDropDatabaseStmt*)pStmt)->dbName, NULL, PRIV_CM_DROP, PRIV_OBJ_DB);
1,097,669✔
874
    case QUERY_NODE_USE_DATABASE_STMT:
2,078,180✔
875
      return authObjPrivileges(pCxt, ((SAlterDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
2,078,180✔
876
    case QUERY_NODE_FLUSH_DATABASE_STMT:
1,731,560✔
877
      return authObjPrivileges(pCxt, ((SFlushDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_FLUSH, PRIV_OBJ_DB);
1,731,560✔
878
    case QUERY_NODE_COMPACT_DATABASE_STMT:
27,223✔
879
      return authObjPrivileges(pCxt, ((SCompactDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_COMPACT, PRIV_OBJ_DB);
27,223✔
880
    case QUERY_NODE_TRIM_DATABASE_STMT:
8,078✔
881
      return authObjPrivileges(pCxt, ((STrimDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_TRIM, PRIV_OBJ_DB);
8,078✔
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:
110✔
885
      return authObjPrivileges(pCxt, ((SScanDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_SCAN, PRIV_OBJ_DB);
110✔
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,809✔
889
      return authShowUsage(pCxt, (SShowStmt*)pStmt);
5,809✔
890
      // check in mnode
891
    case QUERY_NODE_SHOW_VGROUPS_STMT:
602,832✔
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;
602,832✔
898
    default:
68,087,206✔
899
      break;
68,087,206✔
900
  }
901
#endif
902
  return code;
68,087,206✔
903
}
904

905
int32_t authenticate(SParseContext* pParseCxt, SQuery* pQuery, SParseMetaCache* pMetaCache) {
260,472,368✔
906
  SAuthCxt cxt = {.pParseCxt = pParseCxt, .pMetaCache = pMetaCache, .errCode = TSDB_CODE_SUCCESS};
260,472,368✔
907
  return authQuery(&cxt, pQuery->pRoot);
260,475,277✔
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