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

taosdata / TDengine / #4932

19 Jan 2026 12:29PM UTC coverage: 66.646% (-0.1%) from 66.749%
#4932

push

travis-ci

web-flow
chore: upgrade taospy (#34272)

202981 of 304565 relevant lines covered (66.65%)

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

47
  if (NULL == pTabName) {
1,645,349✔
48
    if (pDbName) {
1,005,549✔
49
      int32_t code = tNameSetDbName(&pAuth->tbName, pCxt->acctId, pDbName, strlen(pDbName));
856,940✔
50
      if (TSDB_CODE_SUCCESS != code) return code;
856,940✔
51
    } else {
52
      pAuth->tbName.acctId = pCxt->acctId;
148,609✔
53
      pAuth->tbName.type = TSDB_SYS_NAME_T;
148,609✔
54
    }
55
  } else {
56
    toName(pCxt->acctId, pDbName, pTabName, &pAuth->tbName);
639,800✔
57
  }
58
  pAuth->privType = privType;
1,645,349✔
59
  pAuth->objType = objType;
1,645,349✔
60
  pAuth->isView = isView;
1,645,349✔
61
  return TSDB_CODE_SUCCESS;
1,645,349✔
62
}
63

64
static int32_t checkAuthByOwner(SAuthCxt* pCxt, SUserAuthInfo* pAuthInfo, SUserAuthRes* pAuthRes) {
1,645,349✔
65
  SParseContext*   pParseCxt = pCxt->pParseCxt;
1,645,349✔
66
  const SPrivInfo* pPrivInfo = privInfoGet(pAuthInfo->privType);
1,645,349✔
67
  if (NULL == pPrivInfo) {
1,645,349✔
68
    return TSDB_CODE_PAR_INTERNAL_ERROR;
×
69
  }
70
  int32_t code = 0;
1,645,349✔
71
  if (pPrivInfo->category == PRIV_CATEGORY_OBJECT || pAuthInfo->objType == PRIV_OBJ_DB) {
1,645,349✔
72
    SPrivInfo privInfoDup = *pPrivInfo;
1,102,609✔
73
    if (privInfoDup.objType <= 0) privInfoDup.objType = PRIV_OBJ_DB;
1,102,609✔
74
    switch (privInfoDup.objType) {
1,102,609✔
75
      case PRIV_OBJ_DB: {
856,940✔
76
        SDbCfgInfo dbCfgInfo = {0};
856,940✔
77
        char       dbFName[TSDB_DB_FNAME_LEN] = {0};
856,940✔
78
        (void)tNameGetFullDbName(&pAuthInfo->tbName, dbFName);
856,940✔
79
        code = getDbCfgFromCache(pCxt->pMetaCache, dbFName, &dbCfgInfo);
856,940✔
80
        if (TSDB_CODE_SUCCESS != code) {
856,940✔
81
          return code;
105,760✔
82
        }
83
        if (dbCfgInfo.ownerId == pAuthInfo->userId) {
751,180✔
84
          pAuthRes->pass[pAuthInfo->isView ? AUTH_RES_VIEW : AUTH_RES_BASIC] = true;
2,632✔
85
#if 0
86
          printf("%s:%d db %s owner match, pass\n", __func__, __LINE__, dbFName);
87
#endif
88
          return TSDB_CODE_SUCCESS;
2,632✔
89
        }
90
        break;
748,548✔
91
      }
92
      default:
245,669✔
93
        return TSDB_CODE_SUCCESS;
245,669✔
94
    }
95
  }
96
_exit:
542,740✔
97
  return TSDB_CODE_SUCCESS;
1,291,288✔
98
}
99

100
static int32_t checkAuthImpl(SAuthCxt* pCxt, const char* pDbName, const char* pTabName, EPrivType privType,
549,060,323✔
101
                             EPrivObjType objType, SNode** pCond, bool isView, bool effective) {
102
  SParseContext* pParseCxt = pCxt->pParseCxt;
549,060,323✔
103
  if (pParseCxt->isSuperUser) {
549,061,246✔
104
    return TSDB_CODE_SUCCESS;
547,419,050✔
105
  }
106

107
  AUTH_RES_TYPE auth_res_type = isView ? AUTH_RES_VIEW : AUTH_RES_BASIC;
1,645,349✔
108
  SUserAuthInfo authInfo = {0};
1,645,349✔
109
  int32_t code = setUserAuthInfo(pCxt->pParseCxt, pDbName, pTabName, privType, objType, isView, effective, &authInfo);
1,645,349✔
110
  if (TSDB_CODE_SUCCESS != code) return code;
1,645,349✔
111
  SUserAuthRes authRes = {0};
1,645,349✔
112
  if (NULL != pCxt->pMetaCache) {
1,645,349✔
113
    code = checkAuthByOwner(pCxt, &authInfo, &authRes);
1,645,349✔
114
    if (code == TSDB_CODE_SUCCESS && authRes.pass[auth_res_type]) {
1,645,349✔
115
      goto _exit;
2,632✔
116
    }
117
    code = getUserAuthFromCache(pCxt->pMetaCache, &authInfo, &authRes);
1,642,717✔
118
#ifdef TD_ENTERPRISE
119
    if (isView && TSDB_CODE_PAR_INTERNAL_ERROR == code) {
1,642,717✔
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,645,349✔
132
  if (TSDB_CODE_SUCCESS == code && NULL != pCond) {
1,645,349✔
133
    *pCond = authRes.pCond[auth_res_type];
70,667✔
134
  }
135
  return TSDB_CODE_SUCCESS == code ? (authRes.pass[auth_res_type] ? TSDB_CODE_SUCCESS : TSDB_CODE_PAR_PERMISSION_DENIED)
1,644,346✔
136
                                   : code;
3,289,525✔
137
}
138

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

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

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

158
  return checkAuth(pCxt, pDbName, pTabName, privType, objType, NULL);
297,709,721✔
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,
9,108✔
167
                             EPrivObjType objType, SNode** pCond) {
168
  return checkAuthImpl(pCxt, pDbName, pTabName, privType, objType, pCond, true, false);
9,108✔
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,364,668✔
177
  return TSDB_CODE_SUCCESS == authQuery(pCxt, pStmt) ? DEAL_RES_CONTINUE : DEAL_RES_ERROR;
22,364,668✔
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,607✔
202
  if (QUERY_NODE_COLUMN == nodeType(pNode)) {
5,607✔
203
    SColumnNode*     pCol = (SColumnNode*)pNode;
1,869✔
204
    SAuthRewriteCxt* pCxt = (SAuthRewriteCxt*)pContext;
1,869✔
205
    tstrncpy(pCol->tableName, pCxt->pTarget->tableName, TSDB_TABLE_NAME_LEN);
1,869✔
206
    tstrncpy(pCol->tableAlias, pCxt->pTarget->tableAlias, TSDB_TABLE_NAME_LEN);
1,869✔
207
  }
208

209
  return DEAL_RES_CONTINUE;
5,607✔
210
}
211

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

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

222
  if (NULL == *pWhere) {
1,869✔
223
    *pWhere = pTagCondCopy;
1,869✔
224
    return TSDB_CODE_SUCCESS;
1,869✔
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) {
2,090,674,774✔
236
  SSelectAuthCxt* pCxt = pContext;
2,090,674,774✔
237
  SAuthCxt*       pAuthCxt = pCxt->pAuthCxt;
2,090,674,774✔
238
  bool            isView = false;
2,090,676,172✔
239
  if (QUERY_NODE_REAL_TABLE == nodeType(pNode)) {
2,090,676,172✔
240
    SNode*      pTagCond = NULL;
201,553,290✔
241
    STableNode* pTable = (STableNode*)pNode;
201,553,290✔
242
    if ((pAuthCxt->pParseCxt->enableSysInfo == 0) && IS_INFORMATION_SCHEMA_DB(pTable->dbName) &&
201,553,290✔
243
        (strcmp(pTable->tableName, TSDB_INS_TABLE_VGROUPS) == 0)) {
19,205✔
244
      pAuthCxt->errCode = TSDB_CODE_PAR_PERMISSION_DENIED;
668✔
245
      return DEAL_RES_ERROR;
668✔
246
    }
247
    if (authObjPrivileges(pAuthCxt, pTable->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB) != TSDB_CODE_SUCCESS) {
201,552,077✔
248
      pAuthCxt->errCode = TSDB_CODE_PAR_PERMISSION_DENIED;
1,170✔
249
      return DEAL_RES_ERROR;
1,170✔
250
    }
251
#ifdef TD_ENTERPRISE
252
    SName name = {0};
201,549,963✔
253
    toName(pAuthCxt->pParseCxt->acctId, pTable->dbName, pTable->tableName, &name);
201,550,455✔
254
    STableMeta* pTableMeta = NULL;
201,550,547✔
255
    toName(pAuthCxt->pParseCxt->acctId, pTable->dbName, pTable->tableName, &name);
201,550,564✔
256
    int32_t code = getTargetMetaImpl(pAuthCxt->pParseCxt, pAuthCxt->pMetaCache, &name, &pTableMeta, true);
201,550,917✔
257
    if (TSDB_CODE_SUCCESS == code && TSDB_VIEW_TABLE == pTableMeta->tableType) {
201,550,498✔
258
      isView = true;
9,108✔
259
    }
260
    taosMemoryFree(pTableMeta);
201,551,029✔
261
#endif
262
    if (!isView) {
201,549,897✔
263
      pAuthCxt->errCode =
201,541,897✔
264
          checkAuth(pAuthCxt, pTable->dbName, pTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, &pTagCond);
201,540,789✔
265
      if (TSDB_CODE_SUCCESS != pAuthCxt->errCode && NULL != pAuthCxt->pParseCxt->pEffectiveUser) {
201,542,323✔
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) {
201,542,334✔
270
        pAuthCxt->errCode = rewriteAppendStableTagCond(&pCxt->pSelect->pWhere, pTagCond, pTable);
1,869✔
271
      }
272
    } else {
273
      pAuthCxt->errCode =
9,108✔
274
          checkViewAuth(pAuthCxt, pTable->dbName, pTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, NULL);
9,108✔
275
      if (TSDB_CODE_SUCCESS != pAuthCxt->errCode && NULL != pAuthCxt->pParseCxt->pEffectiveUser) {
9,108✔
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;
201,550,517✔
281
  } else if (QUERY_NODE_TEMP_TABLE == nodeType(pNode)) {
1,889,123,939✔
282
    return authSubquery(pAuthCxt, ((STempTableNode*)pNode)->pSubquery);
22,365,628✔
283
  }
284
  return DEAL_RES_CONTINUE;
1,866,758,294✔
285
}
286

287
static int32_t authSelect(SAuthCxt* pCxt, SSelectStmt* pSelect) {
211,828,570✔
288
  SSelectAuthCxt cxt = {.pAuthCxt = pCxt, .pSelect = pSelect};
211,828,570✔
289
  nodesWalkSelectStmt(pSelect, SQL_CLAUSE_FROM, authSelectImpl, &cxt);
211,828,642✔
290
  return pCxt->errCode;
211,829,151✔
291
}
292

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

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

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

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

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

341
static int32_t authShowVtables(SAuthCxt* pCxt, SShowStmt* pStmt) { return authShowTables(pCxt, pStmt); }
57,735✔
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) {
76,595✔
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));
76,595✔
352
  return authObjPrivileges(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_SHOW_CREATE, PRIV_OBJ_TBL);
73,088✔
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,296,384✔
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,296,384✔
368
  return authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB);
5,296,050✔
369
}
370

371
static int32_t authCreateVTable(SAuthCxt* pCxt, SCreateVTableStmt* pStmt) {
147,995✔
372
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
147,995✔
373
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB));
147,995✔
374
  SNode* pCol = NULL;
137,979✔
375
  FOREACH(pCol, pStmt->pCols) {
1,709,746✔
376
    SColumnDefNode* pColDef = (SColumnDefNode*)pCol;
1,579,279✔
377
    if (NULL == pColDef) {
1,579,279✔
378
      PAR_ERR_RET(TSDB_CODE_PAR_INVALID_COLUMN);
×
379
    }
380
    SColumnOptions* pOptions = (SColumnOptions*)pColDef->pOptions;
1,579,279✔
381
    if (pOptions && pOptions->hasRef) {
1,579,279✔
382
      PAR_ERR_RET(authObjPrivileges(pCxt, pOptions->refDb, pOptions->refTable, PRIV_TBL_SELECT, PRIV_OBJ_TBL));
847,258✔
383
    }
384
  }
385
  return TSDB_CODE_SUCCESS;
130,467✔
386
}
387

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

399
  FOREACH(pNode, pTmpList) {
1,561,594✔
400
    SColumnRefNode* pColRef = (SColumnRefNode*)pNode;
1,352,860✔
401
    if (NULL == pColRef) {
1,352,860✔
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,352,860✔
405
  }
406
  return code;
208,734✔
407
}
408

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

412
  if (IS_SYS_DBNAME(pStmt->streamDbName)) {
281,046✔
413
    return TSDB_CODE_PAR_PERMISSION_DENIED;
×
414
  }
415
  if (IS_SYS_DBNAME(pStmt->targetDbName)) {
281,046✔
416
    return TSDB_CODE_PAR_PERMISSION_DENIED;
39✔
417
  }
418
  if (pStmt->pTrigger) {
281,007✔
419
    SStreamTriggerNode* pTrigger = (SStreamTriggerNode*)pStmt->pTrigger;
281,007✔
420
    STableNode*         pTriggerTable = (STableNode*)pTrigger->pTrigerTable;
281,007✔
421
    if (pTriggerTable) {
281,007✔
422
      if (IS_SYS_DBNAME(pTriggerTable->dbName)) return TSDB_CODE_PAR_PERMISSION_DENIED;
276,487✔
423
      PAR_ERR_RET(
276,448✔
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));
275,588✔
426
    }
427
  }
428

429
  PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->streamDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
280,108✔
430
  PAR_ERR_RET(
280,108✔
431
      authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->streamDbName, NULL, PRIV_STREAM_CREATE, PRIV_OBJ_DB));
432
  if (pStmt->targetDbName[0] != '\0') {
279,463✔
433
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->targetDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
276,280✔
434
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->targetDbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB));
276,280✔
435
  }
436
  if (pStmt->pQuery) {
279,248✔
437
    PAR_ERR_RET(authQuery(pCxt, pStmt->pQuery));
276,065✔
438
  }
439
  return code;
278,818✔
440
}
441

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

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

459
  return code;
171,521✔
460
}
461

462
static int32_t authCreateMultiTable(SAuthCxt* pCxt, SCreateMultiTablesStmt* pStmt) {
31,008,573✔
463
  int32_t code = TSDB_CODE_SUCCESS;
31,008,573✔
464
  SNode*  pNode = NULL;
31,008,573✔
465
  FOREACH(pNode, pStmt->pSubTables) {
68,268,606✔
466
    if (pNode->type == QUERY_NODE_CREATE_SUBTABLE_CLAUSE) {
37,257,283✔
467
      SCreateSubTableClause* pClause = (SCreateSubTableClause*)pNode;
37,260,054✔
468
      code = authObjPrivileges(pCxt, pClause->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
37,260,054✔
469
      if (TSDB_CODE_SUCCESS != code) {
37,257,679✔
470
        break;
167✔
471
      }
472
      code = authObjPrivileges(pCxt, pClause->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB);
37,257,512✔
473
      if (TSDB_CODE_SUCCESS != code) {
37,260,033✔
474
        break;
×
475
      }
476
    } else {
477
      SCreateSubTableFromFileClause* pClause = (SCreateSubTableFromFileClause*)pNode;
×
478
      code = authObjPrivileges(pCxt, pClause->useDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
×
479
      if (TSDB_CODE_SUCCESS != code) {
×
480
        break;
×
481
      }
482
      code = authObjPrivileges(pCxt, pClause->useDbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB);
×
483
      if (TSDB_CODE_SUCCESS != code) {
×
484
        break;
×
485
      }
486
    }
487
  }
488
  return code;
31,010,813✔
489
}
490

491
static int32_t authDropTable(SAuthCxt* pCxt, SDropTableStmt* pStmt) {
2,087,036✔
492
  int32_t code = TSDB_CODE_SUCCESS;
2,087,036✔
493
  if (pStmt->withOpt && !pCxt->pParseCxt->isSuperUser) {
2,087,036✔
494
    return TSDB_CODE_PAR_PERMISSION_DENIED;
272✔
495
  }
496
  SNode* pNode = NULL;
2,086,764✔
497
  FOREACH(pNode, pStmt->pTables) {
4,292,326✔
498
    SDropTableClause* pClause = (SDropTableClause*)pNode;
2,205,562✔
499
    PAR_ERR_RET(checkAuth(pCxt, pClause->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
2,205,562✔
500

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

510
  return code;
2,086,764✔
511
}
512

513
static int32_t authDropStable(SAuthCxt* pCxt, SDropSuperTableStmt* pStmt) {
84,959✔
514
  if (pStmt->withOpt && !pCxt->pParseCxt->isSuperUser) {
84,959✔
515
    return TSDB_CODE_PAR_PERMISSION_DENIED;
136✔
516
  }
517
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
84,823✔
518
  if (!pStmt->withOpt) {
84,823✔
519
    PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_DROP, PRIV_OBJ_TBL, NULL));
30,215✔
520
  }
521
  return 0;
84,823✔
522
}
523

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

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

542
static int32_t authAlterVTable(SAuthCxt* pCxt, SAlterTableStmt* pStmt) {
369,387✔
543
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
369,387✔
544
  PAR_ERR_RET(checkAuth(pCxt, pStmt->dbName, pStmt->tableName, PRIV_CM_ALTER, PRIV_OBJ_TBL, NULL));
369,387✔
545
  if (pStmt->alterType == TSDB_ALTER_TABLE_ADD_COLUMN_WITH_COLUMN_REF ||
314,299✔
546
      pStmt->alterType == TSDB_ALTER_TABLE_ALTER_COLUMN_REF) {
286,124✔
547
    PAR_ERR_RET(checkAuth(pCxt, pStmt->refDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
122,141✔
548
    PAR_ERR_RET(checkAuth(pCxt, pStmt->refDbName, pStmt->refTableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, NULL));
122,141✔
549
  }
550
  PAR_RET(TSDB_CODE_SUCCESS);
294,267✔
551
}
552

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

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

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

598
  return code;
11,853✔
599
}
600

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

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

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

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

633
  return code;
837✔
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) {
110,409✔
646
  int32_t code = authObjPrivileges(pCxt, ((SCreateRsmaStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
110,409✔
647
  if (TSDB_CODE_SUCCESS == code) {
110,409✔
648
    code = authObjPrivileges(pCxt, ((SCreateRsmaStmt*)pStmt)->dbName, ((SCreateRsmaStmt*)pStmt)->tableName,
110,409✔
649
                             PRIV_TBL_SELECT, PRIV_OBJ_TBL);
650
  }
651
  if (TSDB_CODE_SUCCESS == code) {
110,409✔
652
    code = authObjPrivileges(pCxt, ((SCreateRsmaStmt*)pStmt)->dbName, ((SCreateRsmaStmt*)pStmt)->tableName,
110,409✔
653
                             PRIV_TBL_INSERT, PRIV_OBJ_TBL);
654
  }
655
  if (TSDB_CODE_SUCCESS == code) {
110,409✔
656
    code = authObjPrivileges(pCxt, ((SCreateRsmaStmt*)pStmt)->dbName, ((SCreateRsmaStmt*)pStmt)->tableName,
110,409✔
657
                             PRIV_RSMA_CREATE, PRIV_OBJ_TBL);
658
  }
659
  return code;
110,409✔
660
}
661

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

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

681
static int32_t authGrant(SAuthCxt* pCxt, SGrantStmt* pStmt) {
575,556✔
682
  if (pStmt->optrType == TSDB_ALTER_ROLE_ROLE) {
575,556✔
683
    if (IS_SYS_PREFIX(pStmt->roleName)) {
2,338✔
684
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSDBA) == 0) {
2,171✔
685
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_SYSDBA);
167✔
686
      }
687
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSSEC) == 0) {
2,004✔
688
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_SYSSEC);
167✔
689
      }
690
      if (strcmp(pStmt->roleName, TSDB_ROLE_SYSAUDIT) == 0) {
1,837✔
691
        return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_SYSAUDIT);
167✔
692
      }
693
    }
694
  }
695
  return authSysPrivileges(pCxt, (void*)pStmt, PRIV_GRANT_PRIVILEGE);
575,055✔
696
}
697

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

715
static int32_t authQuery(SAuthCxt* pCxt, SNode* pStmt) {
311,344,576✔
716
  int32_t code = TSDB_CODE_SUCCESS;
311,344,576✔
717
#ifdef TD_ENTERPRISE
718
  switch (nodeType(pStmt)) {
311,344,576✔
719
    case QUERY_NODE_SET_OPERATOR:
10,855,969✔
720
      return authSetOperator(pCxt, (SSetOperator*)pStmt);
10,855,969✔
721
    case QUERY_NODE_SELECT_STMT:
211,829,090✔
722
      return authSelect(pCxt, (SSelectStmt*)pStmt);
211,829,090✔
723
    case QUERY_NODE_CREATE_ROLE_STMT:
167✔
724
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_CREATE);
167✔
725
    case QUERY_NODE_DROP_ROLE_STMT:
×
726
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_DROP);
×
727
    case QUERY_NODE_CREATE_USER_STMT:
60,513✔
728
      return authSysPrivileges(pCxt, pStmt, PRIV_USER_CREATE);
60,513✔
729
    case QUERY_NODE_DROP_USER_STMT:
22,737✔
730
      return authDropUser(pCxt, (SDropUserStmt*)pStmt);
22,737✔
731
    case QUERY_NODE_DELETE_STMT:
1,760,745✔
732
      return authDelete(pCxt, (SDeleteStmt*)pStmt);
1,760,745✔
733
    case QUERY_NODE_INSERT_STMT:
227,616✔
734
      return authInsert(pCxt, (SInsertStmt*)pStmt);
227,616✔
735
    case QUERY_NODE_CREATE_TABLE_STMT:
5,296,384✔
736
      return authCreateTable(pCxt, (SCreateTableStmt*)pStmt);
5,296,384✔
737
    case QUERY_NODE_CREATE_VIRTUAL_TABLE_STMT:
147,995✔
738
      return authCreateVTable(pCxt, (SCreateVTableStmt*)pStmt);
147,995✔
739
    case QUERY_NODE_CREATE_VIRTUAL_SUBTABLE_STMT:
237,518✔
740
      return authCreateVSubTable(pCxt, (SCreateVSubTableStmt*)pStmt);
237,518✔
741
    case QUERY_NODE_CREATE_MULTI_TABLES_STMT:
31,008,574✔
742
      return authCreateMultiTable(pCxt, (SCreateMultiTablesStmt*)pStmt);
31,008,574✔
743
    case QUERY_NODE_CREATE_STREAM_STMT:
281,046✔
744
      return authCreateStream(pCxt, (SCreateStreamStmt*)pStmt);
281,046✔
745
    case QUERY_NODE_CREATE_TOPIC_STMT:
171,689✔
746
      return authCreateTopic(pCxt, (SCreateTopicStmt*)pStmt);
171,689✔
747
    case QUERY_NODE_DROP_TABLE_STMT:
2,087,036✔
748
      return authDropTable(pCxt, (SDropTableStmt*)pStmt);
2,087,036✔
749
    case QUERY_NODE_DROP_SUPER_TABLE_STMT:
84,959✔
750
      return authDropStable(pCxt, (SDropSuperTableStmt*)pStmt);
84,959✔
751
    case QUERY_NODE_DROP_VIRTUAL_TABLE_STMT:
70,876✔
752
      return authDropVtable(pCxt, (SDropVirtualTableStmt*)pStmt);
70,876✔
753
    case QUERY_NODE_ALTER_TABLE_STMT:
18,369,078✔
754
    case QUERY_NODE_ALTER_SUPER_TABLE_STMT:
755
      return authAlterTable(pCxt, (SAlterTableStmt*)pStmt);
18,369,078✔
756
    case QUERY_NODE_ALTER_VIRTUAL_TABLE_STMT:
369,387✔
757
      return authAlterVTable(pCxt, (SAlterTableStmt*)pStmt);
369,387✔
758
    case QUERY_NODE_SHOW_MODULES_STMT:
115,028✔
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;
115,028✔
773
    case QUERY_NODE_SHOW_USERS_STMT:
144,178✔
774
    case QUERY_NODE_SHOW_USERS_FULL_STMT:
775
      return authSysPrivileges(pCxt, pStmt, PRIV_USER_SHOW);
144,178✔
776
    case QUERY_NODE_SHOW_ROLES_STMT:
167✔
777
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_SHOW);
167✔
778
    case QUERY_NODE_SHOW_USER_PRIVILEGES_STMT:
3,827✔
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,827✔
782
    case QUERY_NODE_SHOW_DNODES_STMT:
434,197✔
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);
434,197✔
794
    case QUERY_NODE_SHOW_CLUSTER_MACHINES_STMT:
5,644✔
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,644✔
799
    case QUERY_NODE_SHOW_TABLES_STMT:
431,382✔
800
    case QUERY_NODE_SHOW_STABLES_STMT:
801
      return authShowTables(pCxt, (SShowStmt*)pStmt);
431,382✔
802
    case QUERY_NODE_SHOW_VTABLES_STMT:
57,735✔
803
      return authShowVtables(pCxt, (SShowStmt*)pStmt);
57,735✔
804
    case QUERY_NODE_SHOW_CREATE_TABLE_STMT:
76,595✔
805
    case QUERY_NODE_SHOW_CREATE_VTABLE_STMT:
806
    case QUERY_NODE_SHOW_CREATE_STABLE_STMT:
807
      return authShowCreateTable(pCxt, (SShowCreateTableStmt*)pStmt);
76,595✔
808
    case QUERY_NODE_SHOW_CREATE_VIEW_STMT:
×
809
      return authShowCreateView(pCxt, (SShowCreateViewStmt*)pStmt);
×
810
    case QUERY_NODE_CREATE_VIEW_STMT:
18,384✔
811
      return authCreateView(pCxt, (SCreateViewStmt*)pStmt);
18,384✔
812
    case QUERY_NODE_DROP_VIEW_STMT:
×
813
      return authDropView(pCxt, (SDropViewStmt*)pStmt);
×
814
    case QUERY_NODE_CREATE_INDEX_STMT:
11,853✔
815
      return authCreateIndex(pCxt, (SCreateIndexStmt*)pStmt);
11,853✔
816
    case QUERY_NODE_DROP_INDEX_STMT:
3,312✔
817
      return authDropIndex(pCxt, (SDropIndexStmt*)pStmt);
3,312✔
818
    case QUERY_NODE_SHOW_INDEXES_STMT:
4,354✔
819
      return authShowIndexes(pCxt, (SShowStmt*)pStmt);
4,354✔
820
    case QUERY_NODE_CREATE_TSMA_STMT:
837✔
821
      return authCreateTsma(pCxt, (SCreateTSMAStmt*)pStmt);
837✔
822
    case QUERY_NODE_DROP_TSMA_STMT:
×
823
      return authDropTsma(pCxt, (SDropTSMAStmt*)pStmt);
×
824
    case QUERY_NODE_CREATE_RSMA_STMT:
110,409✔
825
      return authCreateRsma(pCxt, (SCreateRsmaStmt*)pStmt);
110,409✔
826
    case QUERY_NODE_DROP_RSMA_STMT:
2,223✔
827
      return authDropRsma(pCxt, (SDropRsmaStmt*)pStmt);
2,223✔
828
    case QUERY_NODE_ALTER_RSMA_STMT:
20,007✔
829
      return authObjPrivileges(pCxt, ((SAlterRsmaStmt*)pStmt)->dbName, ((SAlterRsmaStmt*)pStmt)->rsmaName,
20,007✔
830
                               PRIV_CM_ALTER, PRIV_OBJ_RSMA);
831
    case QUERY_NODE_SHOW_CREATE_RSMA_STMT:
2,223✔
832
      return authShowCreateRsma(pCxt, (SShowCreateRsmaStmt*)pStmt);
2,223✔
833
    case QUERY_NODE_CREATE_DATABASE_STMT:
1,351,006✔
834
      return authSysPrivileges(pCxt, pStmt, PRIV_DB_CREATE);
1,351,006✔
835
    case QUERY_NODE_BALANCE_VGROUP_STMT:
11,577✔
836
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_BALANCE);
11,577✔
837
    case QUERY_NODE_BALANCE_VGROUP_LEADER_DATABASE_STMT:
2,404✔
838
    case QUERY_NODE_BALANCE_VGROUP_LEADER_STMT:
839
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_BALANCE_LEADER);
2,404✔
840
    case QUERY_NODE_MERGE_VGROUP_STMT:
×
841
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_MERGE);
×
842
    case QUERY_NODE_SPLIT_VGROUP_STMT:
17,683✔
843
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_SPLIT);
17,683✔
844
    case QUERY_NODE_REDISTRIBUTE_VGROUP_STMT:
45,633✔
845
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_REDISTRIBUTE);
45,633✔
846
    case QUERY_NODE_CREATE_FUNCTION_STMT:
32,544✔
847
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_CREATE);
32,544✔
848
    case QUERY_NODE_DROP_FUNCTION_STMT:
24,273✔
849
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_DROP);
24,273✔
850
    case QUERY_NODE_SHOW_FUNCTIONS_STMT:
25,767✔
851
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_SHOW);
25,767✔
852
    case QUERY_NODE_GRANT_STMT:
575,556✔
853
      return authGrant(pCxt, (SGrantStmt*)pStmt);
575,556✔
854
    case QUERY_NODE_REVOKE_STMT:
414,237✔
855
      return authRevoke(pCxt, (SRevokeStmt*)pStmt);
414,237✔
856
    case QUERY_NODE_CREATE_DNODE_STMT:
281,793✔
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);
281,793✔
863
    case QUERY_NODE_DROP_DNODE_STMT:
92,293✔
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);
92,293✔
870
    case QUERY_NODE_ALTER_DATABASE_STMT:
181,459✔
871
      return authObjPrivileges(pCxt, ((SAlterDatabaseStmt*)pStmt)->dbName, NULL, PRIV_CM_ALTER, PRIV_OBJ_DB);
181,459✔
872
    case QUERY_NODE_DROP_DATABASE_STMT:
1,114,922✔
873
      return authObjPrivileges(pCxt, ((SDropDatabaseStmt*)pStmt)->dbName, NULL, PRIV_CM_DROP, PRIV_OBJ_DB);
1,114,922✔
874
    case QUERY_NODE_USE_DATABASE_STMT:
2,104,890✔
875
      return authObjPrivileges(pCxt, ((SAlterDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
2,104,890✔
876
    case QUERY_NODE_FLUSH_DATABASE_STMT:
1,764,128✔
877
      return authObjPrivileges(pCxt, ((SFlushDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_FLUSH, PRIV_OBJ_DB);
1,764,128✔
878
    case QUERY_NODE_COMPACT_DATABASE_STMT:
27,332✔
879
      return authObjPrivileges(pCxt, ((SCompactDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_COMPACT, PRIV_OBJ_DB);
27,332✔
880
    case QUERY_NODE_TRIM_DATABASE_STMT:
8,168✔
881
      return authObjPrivileges(pCxt, ((STrimDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_TRIM, PRIV_OBJ_DB);
8,168✔
882
    case QUERY_NODE_ROLLUP_DATABASE_STMT:
9,633✔
883
      return authObjPrivileges(pCxt, ((SRollupDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_ROLLUP, PRIV_OBJ_DB);
9,633✔
884
    case QUERY_NODE_SCAN_DATABASE_STMT:
130✔
885
      return authObjPrivileges(pCxt, ((SScanDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_SCAN, PRIV_OBJ_DB);
130✔
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
2,267✔
889
      return authShowUsage(pCxt, (SShowStmt*)pStmt);
2,267✔
890
      // check in mnode
891
    case QUERY_NODE_SHOW_VGROUPS_STMT:
1,292,300✔
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;
1,292,300✔
898
    default:
17,641,056✔
899
      break;
17,641,056✔
900
  }
901
#endif
902
  return code;
17,641,056✔
903
}
904

905
int32_t authenticate(SParseContext* pParseCxt, SQuery* pQuery, SParseMetaCache* pMetaCache) {
266,835,888✔
906
  SAuthCxt cxt = {.pParseCxt = pParseCxt, .pMetaCache = pMetaCache, .errCode = TSDB_CODE_SUCCESS};
266,835,888✔
907
  return authQuery(&cxt, pQuery->pRoot);
266,836,935✔
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