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

taosdata / TDengine / #4911

04 Jan 2026 09:05AM UTC coverage: 65.028% (-0.8%) from 65.864%
#4911

push

travis-ci

web-flow
merge: from main to 3.0 branch #34156

1206 of 4524 new or added lines in 22 files covered. (26.66%)

1517 existing lines in 134 files now uncovered.

195276 of 300296 relevant lines covered (65.03%)

116931714.52 hits per line

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

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

47
  if (NULL == pTabName) {
1,461,219✔
48
    if (pDbName) {
843,600✔
49
      int32_t code = tNameSetDbName(&pAuth->tbName, pCxt->acctId, pDbName, strlen(pDbName));
824,051✔
50
      if (TSDB_CODE_SUCCESS != code) return code;
824,051✔
51
    } else {
52
      pAuth->tbName.acctId = pCxt->acctId;
19,549✔
53
      pAuth->tbName.type = TSDB_SYS_NAME_T;
19,549✔
54
    }
55
  } else {
56
    toName(pCxt->acctId, pDbName, pTabName, &pAuth->tbName);
617,619✔
57
  }
58
  pAuth->privType = privType;
1,461,219✔
59
  pAuth->objType = objType;
1,461,219✔
60
  pAuth->isView = isView;
1,461,219✔
61
  return TSDB_CODE_SUCCESS;
1,461,219✔
62
}
63

64
static int32_t checkAuthByOwner(SAuthCxt* pCxt, SUserAuthInfo* pAuthInfo, SUserAuthRes* pAuthRes) {
1,461,219✔
65
  SParseContext*   pParseCxt = pCxt->pParseCxt;
1,461,219✔
66
  const SPrivInfo* pPrivInfo = privInfoGet(pAuthInfo->privType);
1,461,219✔
67
  if (NULL == pPrivInfo) {
1,461,219✔
68
    return TSDB_CODE_PAR_INTERNAL_ERROR;
×
69
  }
70
  int32_t code = 0;
1,461,219✔
71
  if (pPrivInfo->category == PRIV_CATEGORY_OBJECT || pAuthInfo->objType == PRIV_OBJ_DB) {
1,461,219✔
72
    SPrivInfo privInfoDup = *pPrivInfo;
1,057,925✔
73
    if (privInfoDup.objType <= 0) privInfoDup.objType = PRIV_OBJ_DB;
1,057,925✔
74
    switch (privInfoDup.objType) {
1,057,925✔
75
      case PRIV_OBJ_DB: {
824,051✔
76
        SDbCfgInfo dbCfgInfo = {0};
824,051✔
77
        char       dbFName[TSDB_DB_FNAME_LEN] = {0};
824,051✔
78
        (void)tNameGetFullDbName(&pAuthInfo->tbName, dbFName);
824,051✔
79
        code = getDbCfgFromCache(pCxt->pMetaCache, dbFName, &dbCfgInfo);
824,051✔
80
        if (TSDB_CODE_SUCCESS != code) {
824,051✔
81
          return code;
101,149✔
82
        }
83
        if (dbCfgInfo.ownerId == pAuthInfo->userId) {
722,902✔
84
          pAuthRes->pass[pAuthInfo->isView ? AUTH_RES_VIEW : AUTH_RES_BASIC] = true;
2,458✔
85
#if 0
86
          printf("%s:%d db %s owner match, pass\n", __func__, __LINE__, dbFName);
87
#endif
88
          return TSDB_CODE_SUCCESS;
2,458✔
89
        }
90
        break;
720,444✔
91
      }
92
      default:
233,874✔
93
        return TSDB_CODE_SUCCESS;
233,874✔
94
    }
95
  }
96
_exit:
403,294✔
97
  return TSDB_CODE_SUCCESS;
1,123,738✔
98
}
99

100
static int32_t checkAuthImpl(SAuthCxt* pCxt, const char* pDbName, const char* pTabName, EPrivType privType,
606,947,526✔
101
                             EPrivObjType objType, SNode** pCond, bool isView, bool effective) {
102
  SParseContext* pParseCxt = pCxt->pParseCxt;
606,947,526✔
103
  if (pParseCxt->isSuperUser) {
606,950,125✔
104
    return TSDB_CODE_SUCCESS;
605,492,173✔
105
  }
106

107
  AUTH_RES_TYPE auth_res_type = isView ? AUTH_RES_VIEW : AUTH_RES_BASIC;
1,461,207✔
108
  SUserAuthInfo authInfo = {0};
1,461,207✔
109
  int32_t code = setUserAuthInfo(pCxt->pParseCxt, pDbName, pTabName, privType, objType, isView, effective, &authInfo);
1,461,207✔
110
  if (TSDB_CODE_SUCCESS != code) return code;
1,461,219✔
111
  SUserAuthRes authRes = {0};
1,461,219✔
112
  if (NULL != pCxt->pMetaCache) {
1,461,219✔
113
    code = checkAuthByOwner(pCxt, &authInfo, &authRes);
1,461,219✔
114
    if (code == TSDB_CODE_SUCCESS && authRes.pass[auth_res_type]) {
1,461,219✔
115
      goto _exit;
2,458✔
116
    }
117
    code = getUserAuthFromCache(pCxt->pMetaCache, &authInfo, &authRes);
1,458,761✔
118
#ifdef TD_ENTERPRISE
119
    if (isView && TSDB_CODE_PAR_INTERNAL_ERROR == code) {
1,458,761✔
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,461,219✔
132
  if (TSDB_CODE_SUCCESS == code && NULL != pCond) {
1,461,219✔
133
    *pCond = authRes.pCond[auth_res_type];
63,684✔
134
  }
135
  return TSDB_CODE_SUCCESS == code ? (authRes.pass[auth_res_type] ? TSDB_CODE_SUCCESS : TSDB_CODE_PAR_PERMISSION_DENIED)
1,460,275✔
136
                                   : code;
2,921,304✔
137
}
138

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

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

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

158
  return checkAuth(pCxt, pDbName, pTabName, privType, objType, NULL);
379,693,315✔
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,538✔
167
                             EPrivObjType objType, SNode** pCond) {
168
  return checkAuthImpl(pCxt, pDbName, pTabName, privType, objType, pCond, true, false);
7,538✔
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) {
21,427,374✔
177
  return TSDB_CODE_SUCCESS == authQuery(pCxt, pStmt) ? DEAL_RES_CONTINUE : DEAL_RES_ERROR;
21,427,374✔
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,481✔
202
  if (QUERY_NODE_COLUMN == nodeType(pNode)) {
5,481✔
203
    SColumnNode*     pCol = (SColumnNode*)pNode;
1,827✔
204
    SAuthRewriteCxt* pCxt = (SAuthRewriteCxt*)pContext;
1,827✔
205
    tstrncpy(pCol->tableName, pCxt->pTarget->tableName, TSDB_TABLE_NAME_LEN);
1,827✔
206
    tstrncpy(pCol->tableAlias, pCxt->pTarget->tableAlias, TSDB_TABLE_NAME_LEN);
1,827✔
207
  }
208

209
  return DEAL_RES_CONTINUE;
5,481✔
210
}
211

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

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

222
  if (NULL == *pWhere) {
1,827✔
223
    *pWhere = pTagCondCopy;
1,827✔
224
    return TSDB_CODE_SUCCESS;
1,827✔
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,817,071,134✔
236
  SSelectAuthCxt* pCxt = pContext;
1,817,071,134✔
237
  SAuthCxt*       pAuthCxt = pCxt->pAuthCxt;
1,817,071,134✔
238
  bool            isView = false;
1,817,071,141✔
239
  if (QUERY_NODE_REAL_TABLE == nodeType(pNode)) {
1,817,071,141✔
240
    SNode*      pTagCond = NULL;
173,293,785✔
241
    STableNode* pTable = (STableNode*)pNode;
173,293,781✔
242
    if ((pAuthCxt->pParseCxt->enableSysInfo == 0) && IS_INFORMATION_SCHEMA_DB(pTable->dbName) &&
173,293,781✔
243
        (strcmp(pTable->tableName, TSDB_INS_TABLE_VGROUPS) == 0)) {
17,741✔
244
      pAuthCxt->errCode = TSDB_CODE_PAR_PERMISSION_DENIED;
628✔
245
      return DEAL_RES_ERROR;
628✔
246
    }
247
    if (authObjPrivileges(pAuthCxt, pTable->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB) != TSDB_CODE_SUCCESS) {
173,292,713✔
248
      pAuthCxt->errCode = TSDB_CODE_PAR_PERMISSION_DENIED;
1,092✔
249
      return DEAL_RES_ERROR;
1,092✔
250
    }
251
#ifdef TD_ENTERPRISE
252
    SName name = {0};
173,291,139✔
253
    toName(pAuthCxt->pParseCxt->acctId, pTable->dbName, pTable->tableName, &name);
173,291,126✔
254
    STableMeta* pTableMeta = NULL;
173,292,603✔
255
    toName(pAuthCxt->pParseCxt->acctId, pTable->dbName, pTable->tableName, &name);
173,292,606✔
256
    int32_t code = getTargetMetaImpl(pAuthCxt->pParseCxt, pAuthCxt->pMetaCache, &name, &pTableMeta, true);
173,292,074✔
257
    if (TSDB_CODE_SUCCESS == code && TSDB_VIEW_TABLE == pTableMeta->tableType) {
173,292,535✔
258
      isView = true;
7,538✔
259
    }
260
    taosMemoryFree(pTableMeta);
173,293,008✔
261
#endif
262
    if (!isView) {
173,291,430✔
263
      pAuthCxt->errCode =
173,285,553✔
264
          checkAuth(pAuthCxt, pTable->dbName, pTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, &pTagCond);
173,283,892✔
265
      if (TSDB_CODE_SUCCESS != pAuthCxt->errCode && NULL != pAuthCxt->pParseCxt->pEffectiveUser) {
173,285,525✔
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) {
173,284,979✔
270
        pAuthCxt->errCode = rewriteAppendStableTagCond(&pCxt->pSelect->pWhere, pTagCond, pTable);
1,827✔
271
      }
272
    } else {
273
      pAuthCxt->errCode =
7,538✔
274
          checkViewAuth(pAuthCxt, pTable->dbName, pTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, NULL);
7,538✔
275
      if (TSDB_CODE_SUCCESS != pAuthCxt->errCode && NULL != pAuthCxt->pParseCxt->pEffectiveUser) {
7,538✔
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;
173,293,060✔
281
  } else if (QUERY_NODE_TEMP_TABLE == nodeType(pNode)) {
1,643,776,846✔
282
    return authSubquery(pAuthCxt, ((STempTableNode*)pNode)->pSubquery);
21,427,394✔
283
  }
284
  return DEAL_RES_CONTINUE;
1,622,350,365✔
285
}
286

287
static int32_t authSelect(SAuthCxt* pCxt, SSelectStmt* pSelect) {
182,674,147✔
288
  SSelectAuthCxt cxt = {.pAuthCxt = pCxt, .pSelect = pSelect};
182,674,147✔
289
  nodesWalkSelectStmt(pSelect, SQL_CLAUSE_FROM, authSelectImpl, &cxt);
182,674,643✔
290
  return pCxt->errCode;
182,674,587✔
291
}
292

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

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

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

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

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

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

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

347
static int32_t authShowCreateTable(SAuthCxt* pCxt, SShowCreateTableStmt* pStmt) {
73,931✔
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));
73,931✔
352
  return authObjPrivileges(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_SHOW_CREATE, PRIV_OBJ_TBL);
70,634✔
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) {
16,369,660✔
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));
16,369,660✔
368
  return authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB);
16,369,346✔
369
}
370

371
static int32_t authCreateVTable(SAuthCxt* pCxt, SCreateVTableStmt* pStmt) {
132,313✔
372
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
132,313✔
373
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB));
132,313✔
374
  SNode* pCol = NULL;
122,569✔
375
  FOREACH(pCol, pStmt->pCols) {
92,377,480✔
376
    SColumnDefNode* pColDef = (SColumnDefNode*)pCol;
92,262,219✔
377
    if (NULL == pColDef) {
92,262,219✔
378
      PAR_ERR_RET(TSDB_CODE_PAR_INVALID_COLUMN);
×
379
    }
380
    SColumnOptions* pOptions = (SColumnOptions*)pColDef->pOptions;
92,262,219✔
381
    if (pOptions && pOptions->hasRef) {
92,262,219✔
382
      PAR_ERR_RET(authObjPrivileges(pCxt, pOptions->refDb, pOptions->refTable, PRIV_TBL_SELECT, PRIV_OBJ_TBL));
57,559,569✔
383
    }
384
  }
385
  return TSDB_CODE_SUCCESS;
115,261✔
386
}
387

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

399
  FOREACH(pNode, pTmpList) {
35,406,587✔
400
    SColumnRefNode* pColRef = (SColumnRefNode*)pNode;
35,218,701✔
401
    if (NULL == pColRef) {
35,218,701✔
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));
35,218,701✔
405
  }
406
  return code;
187,886✔
407
}
408

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

412
  if (IS_SYS_DBNAME(pStmt->streamDbName)) {
251,568✔
413
    return TSDB_CODE_PAR_PERMISSION_DENIED;
×
414
  }
415
  if (IS_SYS_DBNAME(pStmt->targetDbName)) {
251,568✔
416
    return TSDB_CODE_PAR_PERMISSION_DENIED;
41✔
417
  }
418
  if (pStmt->pTrigger) {
251,527✔
419
    SStreamTriggerNode* pTrigger = (SStreamTriggerNode*)pStmt->pTrigger;
251,527✔
420
    STableNode*         pTriggerTable = (STableNode*)pTrigger->pTrigerTable;
251,527✔
421
    if (pTriggerTable) {
251,527✔
422
      if (IS_SYS_DBNAME(pTriggerTable->dbName)) return TSDB_CODE_PAR_PERMISSION_DENIED;
247,273✔
423
      PAR_ERR_RET(
247,232✔
424
          authObjPrivileges(pCxt, pTriggerTable->dbName, pTriggerTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL));
425
    }
426
  }
427

428
  PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->streamDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
250,682✔
429
  PAR_ERR_RET(
250,682✔
430
      authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->streamDbName, NULL, PRIV_STREAM_CREATE, PRIV_OBJ_DB));
431
  PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->targetDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
250,079✔
432
  PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->targetDbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB));
250,079✔
433
  if (pStmt->pQuery) {
249,878✔
434
    PAR_ERR_RET(authQuery(pCxt, pStmt->pQuery));
246,758✔
435
  }
436
  return code;
249,476✔
437
}
438

439
static int32_t authCreateTopic(SAuthCxt* pCxt, SCreateTopicStmt* pStmt) {
165,497✔
440
  int32_t code = TSDB_CODE_SUCCESS;
165,497✔
441

442
  if (IS_SYS_DBNAME(pStmt->subDbName)) {
165,497✔
443
    return TSDB_CODE_PAR_PERMISSION_DENIED;
×
444
  }
445
  if (NULL != pStmt->pQuery) {
165,497✔
446
    PAR_ERR_RET(authQuery(pCxt, pStmt->pQuery));
131,113✔
447
  }
448
  if (NULL != pStmt->pWhere) {
165,338✔
449
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateTopicStmt*)pStmt)->subDbName, ((SCreateTopicStmt*)pStmt)->subSTbName,
6,244✔
450
                                  PRIV_TBL_SELECT, PRIV_OBJ_TBL));
451
  }
452
  if (((SCreateTopicStmt*)pStmt)->subDbName[0] != '\0') {
165,338✔
453
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateTopicStmt*)pStmt)->subDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
34,384✔
454
  }
455

456
  return code;
165,338✔
457
}
458

459
static int32_t authCreateMultiTable(SAuthCxt* pCxt, SCreateMultiTablesStmt* pStmt) {
30,339,271✔
460
  int32_t code = TSDB_CODE_SUCCESS;
30,339,271✔
461
  SNode*  pNode = NULL;
30,339,271✔
462
  FOREACH(pNode, pStmt->pSubTables) {
66,700,145✔
463
    if (pNode->type == QUERY_NODE_CREATE_SUBTABLE_CLAUSE) {
36,365,984✔
464
      SCreateSubTableClause* pClause = (SCreateSubTableClause*)pNode;
36,360,272✔
465
      code = authObjPrivileges(pCxt, pClause->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
36,360,272✔
466
      if (TSDB_CODE_SUCCESS != code) {
36,365,154✔
467
        break;
157✔
468
      }
469
      code = authObjPrivileges(pCxt, pClause->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB);
36,364,997✔
470
      if (TSDB_CODE_SUCCESS != code) {
36,366,633✔
471
        break;
×
472
      }
473
    } else {
474
      SCreateSubTableFromFileClause* pClause = (SCreateSubTableFromFileClause*)pNode;
×
475
      code = authObjPrivileges(pCxt, pClause->useDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
×
476
      if (TSDB_CODE_SUCCESS != code) {
×
477
        break;
×
478
      }
479
      code = authObjPrivileges(pCxt, pClause->useDbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB);
×
UNCOV
480
      if (TSDB_CODE_SUCCESS != code) {
×
481
        break;
×
482
      }
483
    }
484
  }
485
  return code;
30,333,103✔
486
}
487

488
static int32_t authDropTable(SAuthCxt* pCxt, SDropTableStmt* pStmt) {
2,015,014✔
489
  int32_t code = TSDB_CODE_SUCCESS;
2,015,014✔
490
  if (pStmt->withOpt && !pCxt->pParseCxt->isSuperUser) {
2,015,014✔
491
    return TSDB_CODE_PAR_PERMISSION_DENIED;
248✔
492
  }
493
  SNode* pNode = NULL;
2,014,766✔
494
  FOREACH(pNode, pStmt->pTables) {
4,137,720✔
495
    SDropTableClause* pClause = (SDropTableClause*)pNode;
2,122,954✔
496
    PAR_ERR_RET(checkAuth(pCxt, pClause->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
2,122,954✔
497

498
    if (!pStmt->withOpt) {
2,122,954✔
499
      // for child table, check privileges of its super table later
500
      if (checkAuth(pCxt, pClause->dbName, pClause->tableName, PRIV_CM_DROP, PRIV_OBJ_TBL, NULL)) {
1,986,712✔
501
        code = TSDB_CODE_PAR_PERMISSION_DENIED;
×
502
        break;
×
503
      }
504
    }
505
  }
506

507
  return code;
2,014,766✔
508
}
509

510
static int32_t authDropStable(SAuthCxt* pCxt, SDropSuperTableStmt* pStmt) {
81,189✔
511
  if (pStmt->withOpt && !pCxt->pParseCxt->isSuperUser) {
81,189✔
512
    return TSDB_CODE_PAR_PERMISSION_DENIED;
124✔
513
  }
514
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
81,065✔
515
  if (!pStmt->withOpt) {
81,065✔
516
    PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_DROP, PRIV_OBJ_TBL, NULL));
29,704✔
517
  }
518
  return 0;
81,065✔
519
}
520

521
static int32_t authDropVtable(SAuthCxt* pCxt, SDropVirtualTableStmt* pStmt) {
68,855✔
522
  if (pStmt->withOpt && !pCxt->pParseCxt->isSuperUser) {
68,855✔
523
    return TSDB_CODE_PAR_PERMISSION_DENIED;
×
524
  }
525
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
68,855✔
526
  if (!pStmt->withOpt) {
68,855✔
527
    PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_DROP, PRIV_OBJ_TBL, NULL));
68,855✔
528
  }
529
  return 0;
59,103✔
530
}
531

532
static int32_t authAlterTable(SAuthCxt* pCxt, SAlterTableStmt* pStmt) {
20,857,688✔
533
  SNode* pTagCond = NULL;
20,857,688✔
534
  // todo check tag condition for subtable
535
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
20,857,688✔
536
  return checkAuth(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_ALTER, PRIV_OBJ_TBL, NULL);
20,856,764✔
537
}
538

539
static int32_t authAlterVTable(SAuthCxt* pCxt, SAlterTableStmt* pStmt) {
361,537✔
540
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
361,537✔
541
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_ALTER, PRIV_OBJ_TBL, NULL));
361,537✔
542
  if (pStmt->alterType == TSDB_ALTER_TABLE_ADD_COLUMN_WITH_COLUMN_REF ||
307,881✔
543
      pStmt->alterType == TSDB_ALTER_TABLE_ALTER_COLUMN_REF) {
280,421✔
544
    PAR_ERR_RET(checkAuth(pCxt, pStmt->refDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
118,831✔
545
    PAR_ERR_RET(checkAuth(pCxt, pStmt->refDbName, pStmt->refTableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, NULL));
118,831✔
546
  }
547
  PAR_RET(TSDB_CODE_SUCCESS);
288,369✔
548
}
549

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

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

582
static int32_t authCreateIndex(SAuthCxt* pCxt, SCreateIndexStmt* pStmt) {
11,480✔
583
  int32_t code = authObjPrivileges(pCxt, ((SCreateIndexStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
11,480✔
584

585
  if (TSDB_CODE_SUCCESS == code) {
11,480✔
586
    code = authObjPrivileges(pCxt, ((SCreateIndexStmt*)pStmt)->dbName, ((SCreateIndexStmt*)pStmt)->tableName,
11,480✔
587
                             PRIV_TBL_SELECT, PRIV_OBJ_TBL);
588
  }
589

590
  if (TSDB_CODE_SUCCESS == code) {
11,480✔
591
    code = authObjPrivileges(pCxt, ((SCreateIndexStmt*)pStmt)->dbName, ((SCreateIndexStmt*)pStmt)->tableName,
11,480✔
592
                             PRIV_IDX_CREATE, PRIV_OBJ_TBL);
593
  }
594

595
  return code;
11,480✔
596
}
597

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

607
static int32_t authShowIndexes(SAuthCxt* pCxt, SShowStmt* pStmt) { return authShowTables(pCxt, pStmt); }
4,142✔
608

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

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

630
  return code;
799✔
631
}
632

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

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

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

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

678
static int32_t authGrant(SAuthCxt* pCxt, SGrantStmt* pStmt) {
557,507✔
679
  if (pStmt->optrType == TSDB_ALTER_ROLE_ROLE) {
557,507✔
680
    if (IS_SYS_PREFIX(pStmt->roleName)) {
2,184✔
681
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSDBA) == 0) {
2,029✔
682
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_SYSDBA);
155✔
683
      }
684
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSSEC) == 0) {
1,874✔
685
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_SYSSEC);
155✔
686
      }
687
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSAUDIT) == 0) {
1,719✔
688
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_SYSAUDIT);
155✔
689
      }
690
    }
691
  }
692
  return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_PRIVILEGE);
557,042✔
693
}
694

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

712
static int32_t authQuery(SAuthCxt* pCxt, SNode* pStmt) {
291,732,216✔
713
  int32_t code = TSDB_CODE_SUCCESS;
291,732,216✔
714
#ifdef TD_ENTERPRISE
715
  switch (nodeType(pStmt)) {
291,732,216✔
716
    case QUERY_NODE_SET_OPERATOR:
9,830,034✔
717
      return authSetOperator(pCxt, (SSetOperator*)pStmt);
9,830,034✔
718
    case QUERY_NODE_SELECT_STMT:
182,673,570✔
719
      return authSelect(pCxt, (SSelectStmt*)pStmt);
182,673,570✔
720
    case QUERY_NODE_CREATE_ROLE_STMT:
155✔
721
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_CREATE);
155✔
722
    case QUERY_NODE_DROP_ROLE_STMT:
×
723
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_DROP);
×
724
    case QUERY_NODE_CREATE_USER_STMT:
48,124✔
725
      return authSysPrivileges(pCxt, pStmt, PRIV_USER_CREATE);
48,124✔
726
    case QUERY_NODE_DROP_USER_STMT:
21,029✔
727
      return authDropUser(pCxt, (SDropUserStmt*)pStmt);
21,029✔
728
    case QUERY_NODE_DELETE_STMT:
1,696,322✔
729
      return authDelete(pCxt, (SDeleteStmt*)pStmt);
1,696,322✔
730
    case QUERY_NODE_INSERT_STMT:
141,727✔
731
      return authInsert(pCxt, (SInsertStmt*)pStmt);
141,727✔
732
    case QUERY_NODE_CREATE_TABLE_STMT:
16,369,660✔
733
      return authCreateTable(pCxt, (SCreateTableStmt*)pStmt);
16,369,660✔
734
    case QUERY_NODE_CREATE_VIRTUAL_TABLE_STMT:
132,313✔
735
      return authCreateVTable(pCxt, (SCreateVTableStmt*)pStmt);
132,313✔
736
    case QUERY_NODE_CREATE_VIRTUAL_SUBTABLE_STMT:
210,878✔
737
      return authCreateVSubTable(pCxt, (SCreateVSubTableStmt*)pStmt);
210,878✔
738
    case QUERY_NODE_CREATE_MULTI_TABLES_STMT:
30,338,927✔
739
      return authCreateMultiTable(pCxt, (SCreateMultiTablesStmt*)pStmt);
30,338,927✔
740
    case QUERY_NODE_CREATE_STREAM_STMT:
251,568✔
741
      return authCreateStream(pCxt, (SCreateStreamStmt*)pStmt);
251,568✔
742
    case QUERY_NODE_CREATE_TOPIC_STMT:
165,497✔
743
      return authCreateTopic(pCxt, (SCreateTopicStmt*)pStmt);
165,497✔
744
    case QUERY_NODE_DROP_TABLE_STMT:
2,015,014✔
745
      return authDropTable(pCxt, (SDropTableStmt*)pStmt);
2,015,014✔
746
    case QUERY_NODE_DROP_SUPER_TABLE_STMT:
81,189✔
747
      return authDropStable(pCxt, (SDropSuperTableStmt*)pStmt);
81,189✔
748
    case QUERY_NODE_DROP_VIRTUAL_TABLE_STMT:
68,855✔
749
      return authDropVtable(pCxt, (SDropVirtualTableStmt*)pStmt);
68,855✔
750
    case QUERY_NODE_ALTER_TABLE_STMT:
20,857,688✔
751
    case QUERY_NODE_ALTER_SUPER_TABLE_STMT:
752
      return authAlterTable(pCxt, (SAlterTableStmt*)pStmt);
20,857,688✔
753
    case QUERY_NODE_ALTER_VIRTUAL_TABLE_STMT:
361,537✔
754
      return authAlterVTable(pCxt, (SAlterTableStmt*)pStmt);
361,537✔
755
    case QUERY_NODE_SHOW_MODULES_STMT:
109,505✔
756
    case QUERY_NODE_SHOW_BACKUP_NODES_STMT:
757
    case QUERY_NODE_SHOW_CLUSTER_STMT:
758
    case QUERY_NODE_SHOW_DB_ALIVE_STMT:
759
    // case QUERY_NODE_SHOW_CLUSTER_ALIVE_STMT:
760
    case QUERY_NODE_SHOW_CREATE_DATABASE_STMT:
761
    case QUERY_NODE_SHOW_TABLE_DISTRIBUTED_STMT:  // TODO: check in mnode
762
    case QUERY_NODE_SHOW_DNODE_VARIABLES_STMT:
763
    case QUERY_NODE_SHOW_SCORES_STMT:
764
    case QUERY_NODE_SHOW_ARBGROUPS_STMT:
765
    case QUERY_NODE_SHOW_ENCRYPTIONS_STMT:
766
    case QUERY_NODE_SHOW_MOUNTS_STMT:
767
    case QUERY_NODE_SHOW_ENCRYPT_ALGORITHMS_STMT:
768
    case QUERY_NODE_SHOW_ENCRYPT_STATUS_STMT:
769
      return !pCxt->pParseCxt->enableSysInfo ? TSDB_CODE_PAR_PERMISSION_DENIED : TSDB_CODE_SUCCESS;
109,505✔
770
    case QUERY_NODE_SHOW_USERS_STMT:
3,705✔
771
    case QUERY_NODE_SHOW_USERS_FULL_STMT:
772
      return authSysPrivileges(pCxt, pStmt, PRIV_USER_SHOW);
3,705✔
773
    case QUERY_NODE_SHOW_ROLES_STMT:
155✔
774
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_SHOW);
155✔
775
    case QUERY_NODE_SHOW_USER_PRIVILEGES_STMT:
3,577✔
776
    case QUERY_NODE_SHOW_ROLE_PRIVILEGES_STMT:
777
    case QUERY_NODE_SHOW_ROLE_COL_PRIVILEGES_STMT:
778
      return authSysPrivileges(pCxt, pStmt, PRIV_SHOW_PRIVILEGES);
3,577✔
779
    case QUERY_NODE_SHOW_DNODES_STMT:
420,321✔
780
    case QUERY_NODE_SHOW_MNODES_STMT:
781
    case QUERY_NODE_SHOW_QNODES_STMT:
782
    case QUERY_NODE_SHOW_SNODES_STMT:
783
    case QUERY_NODE_SHOW_BNODES_STMT:
784
    case QUERY_NODE_SHOW_ANODES_STMT:
785
    case QUERY_NODE_SHOW_ANODES_FULL_STMT:
786
    case QUERY_NODE_SHOW_XNODES_STMT: // TODO: check auth for xnode resources
787
    case QUERY_NODE_SHOW_XNODE_TASKS_STMT:
788
    case QUERY_NODE_SHOW_XNODE_AGENTS_STMT:
789
    case QUERY_NODE_SHOW_XNODE_JOBS_STMT:
790
      return authSysPrivileges(pCxt, pStmt, PRIV_NODES_SHOW);
420,321✔
791
    case QUERY_NODE_SHOW_CLUSTER_MACHINES_STMT:
5,518✔
792
    case QUERY_NODE_SHOW_LICENCES_STMT:
793
    case QUERY_NODE_SHOW_GRANTS_FULL_STMT:
794
    case QUERY_NODE_SHOW_GRANTS_LOGS_STMT:
795
      return authSysPrivileges(pCxt, pStmt, PRIV_GRANTS_SHOW);
5,518✔
796
    case QUERY_NODE_SHOW_TABLES_STMT:
457,165✔
797
    case QUERY_NODE_SHOW_STABLES_STMT:
798
      return authShowTables(pCxt, (SShowStmt*)pStmt);
457,165✔
799
    case QUERY_NODE_SHOW_VTABLES_STMT:
56,618✔
800
      return authShowVtables(pCxt, (SShowStmt*)pStmt);
56,618✔
801
    case QUERY_NODE_SHOW_CREATE_TABLE_STMT:
73,931✔
802
    case QUERY_NODE_SHOW_CREATE_VTABLE_STMT:
803
    case QUERY_NODE_SHOW_CREATE_STABLE_STMT:
804
      return authShowCreateTable(pCxt, (SShowCreateTableStmt*)pStmt);
73,931✔
805
    case QUERY_NODE_SHOW_CREATE_VIEW_STMT:
×
806
      return authShowCreateView(pCxt, (SShowCreateViewStmt*)pStmt);
×
807
    case QUERY_NODE_CREATE_VIEW_STMT:
17,618✔
808
      return authCreateView(pCxt, (SCreateViewStmt*)pStmt);
17,618✔
809
    case QUERY_NODE_DROP_VIEW_STMT:
×
810
      return authDropView(pCxt, (SDropViewStmt*)pStmt);
×
811
    case QUERY_NODE_CREATE_INDEX_STMT:
11,480✔
812
      return authCreateIndex(pCxt, (SCreateIndexStmt*)pStmt);
11,480✔
813
    case QUERY_NODE_DROP_INDEX_STMT:
3,207✔
814
      return authDropIndex(pCxt, (SDropIndexStmt*)pStmt);
3,207✔
815
    case QUERY_NODE_SHOW_INDEXES_STMT:
4,142✔
816
      return authShowIndexes(pCxt, (SShowStmt*)pStmt);
4,142✔
817
    case QUERY_NODE_CREATE_TSMA_STMT:
799✔
818
      return authCreateTsma(pCxt, (SCreateTSMAStmt*)pStmt);
799✔
819
    case QUERY_NODE_DROP_TSMA_STMT:
×
820
      return authDropTsma(pCxt, (SDropTSMAStmt*)pStmt);
×
821
    case QUERY_NODE_CREATE_RSMA_STMT:
108,621✔
822
      return authCreateRsma(pCxt, (SCreateRsmaStmt*)pStmt);
108,621✔
823
    case QUERY_NODE_DROP_RSMA_STMT:
2,187✔
824
      return authDropRsma(pCxt, (SDropRsmaStmt*)pStmt);
2,187✔
825
    case QUERY_NODE_ALTER_RSMA_STMT:
19,683✔
826
      return authObjPrivileges(pCxt, ((SAlterRsmaStmt*)pStmt)->dbName, ((SAlterRsmaStmt*)pStmt)->rsmaName,
19,683✔
827
                               PRIV_CM_ALTER, PRIV_OBJ_RSMA);
828
    case QUERY_NODE_SHOW_CREATE_RSMA_STMT:
2,187✔
829
      return authShowCreateRsma(pCxt, (SShowCreateRsmaStmt*)pStmt);
2,187✔
830
    case QUERY_NODE_CREATE_DATABASE_STMT:
1,292,120✔
831
      return authSysPrivileges(pCxt, pStmt, PRIV_DB_CREATE);
1,292,120✔
832
    case QUERY_NODE_BALANCE_VGROUP_STMT:
11,788✔
833
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_BALANCE);
11,788✔
834
    case QUERY_NODE_BALANCE_VGROUP_LEADER_DATABASE_STMT:
2,776✔
835
    case QUERY_NODE_BALANCE_VGROUP_LEADER_STMT:
836
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_BALANCE_LEADER);
2,776✔
837
    case QUERY_NODE_MERGE_VGROUP_STMT:
×
838
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_MERGE);
×
839
    case QUERY_NODE_SPLIT_VGROUP_STMT:
16,802✔
840
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_SPLIT);
16,802✔
841
    case QUERY_NODE_REDISTRIBUTE_VGROUP_STMT:
44,724✔
842
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_REDISTRIBUTE);
44,724✔
843
    case QUERY_NODE_CREATE_FUNCTION_STMT:
14,151✔
844
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_CREATE);
14,151✔
845
    case QUERY_NODE_DROP_FUNCTION_STMT:
8,502✔
846
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_DROP);
8,502✔
847
    case QUERY_NODE_SHOW_FUNCTIONS_STMT:
10,681✔
848
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_SHOW);
10,681✔
849
    case QUERY_NODE_GRANT_STMT:
557,507✔
850
      return authGrant(pCxt, (SGrantStmt*)pStmt);
557,507✔
851
    case QUERY_NODE_REVOKE_STMT:
402,555✔
852
      return authRevoke(pCxt, (SRevokeStmt*)pStmt);
402,555✔
853
    case QUERY_NODE_CREATE_DNODE_STMT:
267,772✔
854
    case QUERY_NODE_CREATE_MNODE_STMT:
855
    case QUERY_NODE_CREATE_QNODE_STMT:
856
    case QUERY_NODE_CREATE_SNODE_STMT:
857
    case QUERY_NODE_CREATE_BNODE_STMT:
858
    case QUERY_NODE_CREATE_ANODE_STMT:
859
      return authSysPrivileges(pCxt, pStmt, PRIV_NODE_CREATE);
267,772✔
860
    case QUERY_NODE_DROP_DNODE_STMT:
88,215✔
861
    case QUERY_NODE_DROP_MNODE_STMT:
862
    case QUERY_NODE_DROP_QNODE_STMT:
863
    case QUERY_NODE_DROP_SNODE_STMT:
864
    case QUERY_NODE_DROP_BNODE_STMT:
865
    case QUERY_NODE_DROP_ANODE_STMT:
866
      return authSysPrivileges(pCxt, pStmt, PRIV_NODE_DROP);
88,215✔
867
    case QUERY_NODE_ALTER_DATABASE_STMT:
178,476✔
868
      return authObjPrivileges(pCxt, ((SAlterDatabaseStmt*)pStmt)->dbName, NULL, PRIV_CM_ALTER, PRIV_OBJ_DB);
178,476✔
869
    case QUERY_NODE_DROP_DATABASE_STMT:
1,066,105✔
870
      return authObjPrivileges(pCxt, ((SDropDatabaseStmt*)pStmt)->dbName, NULL, PRIV_CM_DROP, PRIV_OBJ_DB);
1,066,105✔
871
    case QUERY_NODE_USE_DATABASE_STMT:
1,997,715✔
872
      return authObjPrivileges(pCxt, ((SAlterDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
1,997,715✔
873
    case QUERY_NODE_FLUSH_DATABASE_STMT:
1,724,538✔
874
      return authObjPrivileges(pCxt, ((SFlushDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_FLUSH, PRIV_OBJ_DB);
1,724,538✔
875
    case QUERY_NODE_COMPACT_DATABASE_STMT:
27,090✔
876
      return authObjPrivileges(pCxt, ((SCompactDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_COMPACT, PRIV_OBJ_DB);
27,090✔
877
    case QUERY_NODE_TRIM_DATABASE_STMT:
8,019✔
878
      return authObjPrivileges(pCxt, ((STrimDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_TRIM, PRIV_OBJ_DB);
8,019✔
879
    case QUERY_NODE_ROLLUP_DATABASE_STMT:
9,477✔
880
      return authObjPrivileges(pCxt, ((SRollupDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_ROLLUP, PRIV_OBJ_DB);
9,477✔
881
    case QUERY_NODE_SCAN_DATABASE_STMT:
112✔
882
      return authObjPrivileges(pCxt, ((SScanDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_SCAN, PRIV_OBJ_DB);
112✔
883
    case QUERY_NODE_SSMIGRATE_DATABASE_STMT:
×
884
      return authObjPrivileges(pCxt, ((SSsMigrateDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_SSMIGRATE, PRIV_OBJ_DB);
×
885
    case QUERY_NODE_SHOW_USAGE_STMT:  // disk info
3,840✔
886
      return authShowUsage(pCxt, (SShowStmt*)pStmt);
3,840✔
887
      // check in mnode
888
    case QUERY_NODE_SHOW_VGROUPS_STMT:
618,532✔
889
    case QUERY_NODE_SHOW_VNODES_STMT:
890
    case QUERY_NODE_SHOW_COMPACTS_STMT:
891
    case QUERY_NODE_SHOW_RETENTIONS_STMT:
892
    case QUERY_NODE_SHOW_SCANS_STMT:
893
    case QUERY_NODE_SHOW_SSMIGRATES_STMT:
894
      return TSDB_CODE_SUCCESS;
618,532✔
895
    default:
16,818,811✔
896
      break;
16,818,811✔
897
  }
898
#endif
899
  return code;
16,818,811✔
900
}
901

902
int32_t authenticate(SParseContext* pParseCxt, SQuery* pQuery, SParseMetaCache* pMetaCache) {
250,249,008✔
903
  SAuthCxt cxt = {.pParseCxt = pParseCxt, .pMetaCache = pMetaCache, .errCode = TSDB_CODE_SUCCESS};
250,249,008✔
904
  return authQuery(&cxt, pQuery->pRoot);
250,250,657✔
905
}
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