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

taosdata / TDengine / #4937

23 Jan 2026 09:40AM UTC coverage: 66.794% (+0.05%) from 66.746%
#4937

push

travis-ci

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

204171 of 305671 relevant lines covered (66.79%)

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

47
  if (NULL == pTabName) {
1,601,772✔
48
    if (pDbName) {
970,519✔
49
      int32_t code = tNameSetDbName(&pAuth->tbName, pCxt->acctId, pDbName, strlen(pDbName));
844,999✔
50
      if (TSDB_CODE_SUCCESS != code) return code;
844,999✔
51
    } else {
52
      pAuth->tbName.acctId = pCxt->acctId;
125,520✔
53
      pAuth->tbName.type = TSDB_SYS_NAME_T;
125,520✔
54
    }
55
  } else {
56
    toName(pCxt->acctId, pDbName, pTabName, &pAuth->tbName);
631,253✔
57
  }
58
  pAuth->privType = privType;
1,601,772✔
59
  pAuth->objType = objType;
1,601,772✔
60
  pAuth->isView = isView;
1,601,772✔
61
  return TSDB_CODE_SUCCESS;
1,601,772✔
62
}
63

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

100
static int32_t checkAuthImpl(SAuthCxt* pCxt, const char* pDbName, const char* pTabName, EPrivType privType,
559,599,271✔
101
                             EPrivObjType objType, SNode** pCond, bool isView, bool effective) {
102
  SParseContext* pParseCxt = pCxt->pParseCxt;
559,599,271✔
103
  if (pParseCxt->isSuperUser) {
559,601,503✔
104
    return TSDB_CODE_SUCCESS;
558,000,318✔
105
  }
106

107
  AUTH_RES_TYPE auth_res_type = isView ? AUTH_RES_VIEW : AUTH_RES_BASIC;
1,601,750✔
108
  SUserAuthInfo authInfo = {0};
1,601,750✔
109
  int32_t code = setUserAuthInfo(pCxt->pParseCxt, pDbName, pTabName, privType, objType, isView, effective, &authInfo);
1,601,750✔
110
  if (TSDB_CODE_SUCCESS != code) return code;
1,601,772✔
111
  SUserAuthRes authRes = {0};
1,601,772✔
112
  if (NULL != pCxt->pMetaCache) {
1,601,772✔
113
    code = checkAuthByOwner(pCxt, &authInfo, &authRes);
1,601,772✔
114
    if (code == TSDB_CODE_SUCCESS && authRes.pass[auth_res_type]) {
1,601,772✔
115
      goto _exit;
2,560✔
116
    }
117
    code = getUserAuthFromCache(pCxt->pMetaCache, &authInfo, &authRes);
1,599,212✔
118
#ifdef TD_ENTERPRISE
119
    if (isView && TSDB_CODE_PAR_INTERNAL_ERROR == code) {
1,599,212✔
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,601,772✔
132
  if (TSDB_CODE_SUCCESS == code && NULL != pCond) {
1,601,772✔
133
    *pCond = authRes.pCond[auth_res_type];
68,923✔
134
  }
135
  return TSDB_CODE_SUCCESS == code ? (authRes.pass[auth_res_type] ? TSDB_CODE_SUCCESS : TSDB_CODE_PAR_PERMISSION_DENIED)
1,600,787✔
136
                                   : code;
3,202,379✔
137
}
138

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

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

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

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

209
  return DEAL_RES_CONTINUE;
5,535✔
210
}
211

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

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

222
  if (NULL == *pWhere) {
1,845✔
223
    *pWhere = pTagCondCopy;
1,845✔
224
    return TSDB_CODE_SUCCESS;
1,845✔
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,600,321,896✔
236
  SSelectAuthCxt* pCxt = pContext;
1,600,321,896✔
237
  SAuthCxt*       pAuthCxt = pCxt->pAuthCxt;
1,600,321,896✔
238
  bool            isView = false;
1,600,321,938✔
239
  if (QUERY_NODE_REAL_TABLE == nodeType(pNode)) {
1,600,321,938✔
240
    SNode*      pTagCond = NULL;
139,406,084✔
241
    STableNode* pTable = (STableNode*)pNode;
139,406,439✔
242
    if ((pAuthCxt->pParseCxt->enableSysInfo == 0) && IS_INFORMATION_SCHEMA_DB(pTable->dbName) &&
139,406,439✔
243
        (strcmp(pTable->tableName, TSDB_INS_TABLE_VGROUPS) == 0)) {
18,856✔
244
      pAuthCxt->errCode = TSDB_CODE_PAR_PERMISSION_DENIED;
656✔
245
      return DEAL_RES_ERROR;
656✔
246
    }
247
    if (authObjPrivileges(pAuthCxt, pTable->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB) != TSDB_CODE_SUCCESS) {
139,405,374✔
248
      pAuthCxt->errCode = TSDB_CODE_PAR_PERMISSION_DENIED;
1,134✔
249
      return DEAL_RES_ERROR;
1,134✔
250
    }
251
#ifdef TD_ENTERPRISE
252
    SName name = {0};
139,402,876✔
253
    toName(pAuthCxt->pParseCxt->acctId, pTable->dbName, pTable->tableName, &name);
139,404,265✔
254
    STableMeta* pTableMeta = NULL;
139,404,293✔
255
    toName(pAuthCxt->pParseCxt->acctId, pTable->dbName, pTable->tableName, &name);
139,404,739✔
256
    int32_t code = getTargetMetaImpl(pAuthCxt->pParseCxt, pAuthCxt->pMetaCache, &name, &pTableMeta, true);
139,404,338✔
257
    if (TSDB_CODE_SUCCESS == code && TSDB_VIEW_TABLE == pTableMeta->tableType) {
139,403,728✔
258
      isView = true;
7,333✔
259
    }
260
    taosMemoryFree(pTableMeta);
139,404,627✔
261
#endif
262
    if (!isView) {
139,401,817✔
263
      pAuthCxt->errCode =
139,397,464✔
264
          checkAuth(pAuthCxt, pTable->dbName, pTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, &pTagCond);
139,394,484✔
265
      if (TSDB_CODE_SUCCESS != pAuthCxt->errCode && NULL != pAuthCxt->pParseCxt->pEffectiveUser) {
139,397,476✔
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) {
139,396,999✔
270
        pAuthCxt->errCode = rewriteAppendStableTagCond(&pCxt->pSelect->pWhere, pTagCond, pTable);
1,845✔
271
      }
272
    } else {
273
      pAuthCxt->errCode =
7,333✔
274
          checkViewAuth(pAuthCxt, pTable->dbName, pTable->tableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL, NULL);
7,333✔
275
      if (TSDB_CODE_SUCCESS != pAuthCxt->errCode && NULL != pAuthCxt->pParseCxt->pEffectiveUser) {
7,333✔
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;
139,404,346✔
281
  } else if (QUERY_NODE_TEMP_TABLE == nodeType(pNode)) {
1,460,921,487✔
282
    return authSubquery(pAuthCxt, ((STempTableNode*)pNode)->pSubquery);
22,201,413✔
283
  }
284
  return DEAL_RES_CONTINUE;
1,438,717,756✔
285
}
286

287
static int32_t authSelect(SAuthCxt* pCxt, SSelectStmt* pSelect) {
151,308,282✔
288
  SSelectAuthCxt cxt = {.pAuthCxt = pCxt, .pSelect = pSelect};
151,308,282✔
289
  nodesWalkSelectStmt(pSelect, SQL_CLAUSE_FROM, authSelectImpl, &cxt);
151,308,328✔
290
  return pCxt->errCode;
151,308,800✔
291
}
292

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

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

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

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

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

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

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

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

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

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

371
static int32_t authCreateVTable(SAuthCxt* pCxt, SCreateVTableStmt* pStmt) {
151,201✔
372
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
151,201✔
373
  PAR_ERR_RET(authObjPrivileges(pCxt, pStmt->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB));
151,201✔
374
  SNode* pCol = NULL;
141,345✔
375
  FOREACH(pCol, pStmt->pCols) {
135,653,465✔
376
    SColumnDefNode* pColDef = (SColumnDefNode*)pCol;
135,519,512✔
377
    if (NULL == pColDef) {
135,519,512✔
378
      PAR_ERR_RET(TSDB_CODE_PAR_INVALID_COLUMN);
×
379
    }
380
    SColumnOptions* pOptions = (SColumnOptions*)pColDef->pOptions;
135,519,512✔
381
    if (pOptions && pOptions->hasRef) {
135,519,512✔
382
      PAR_ERR_RET(authObjPrivileges(pCxt, pOptions->refDb, pOptions->refTable, PRIV_TBL_SELECT, PRIV_OBJ_TBL));
84,563,515✔
383
    }
384
  }
385
  return TSDB_CODE_SUCCESS;
133,953✔
386
}
387

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

399
  FOREACH(pNode, pTmpList) {
51,812,634✔
400
    SColumnRefNode* pColRef = (SColumnRefNode*)pNode;
51,603,074✔
401
    if (NULL == pColRef) {
51,603,074✔
402
      PAR_ERR_RET(TSDB_CODE_PAR_INVALID_COLUMN);
×
403
    }
404
    PAR_ERR_RET(authObjPrivileges(pCxt, pColRef->refDbName, pColRef->refTableName, PRIV_TBL_SELECT, PRIV_OBJ_TBL));
51,603,074✔
405
  }
406
  return code;
209,560✔
407
}
408

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

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

429
  PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->streamDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
282,917✔
430
  PAR_ERR_RET(
282,917✔
431
      authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->streamDbName, NULL, PRIV_STREAM_CREATE, PRIV_OBJ_DB));
432
  if (pStmt->targetDbName[0] != '\0') {
282,290✔
433
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->targetDbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB));
279,224✔
434
    PAR_ERR_RET(authObjPrivileges(pCxt, ((SCreateStreamStmt*)pStmt)->targetDbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB));
279,224✔
435
  }
436
  if (pStmt->pQuery) {
282,081✔
437
    PAR_ERR_RET(authQuery(pCxt, pStmt->pQuery));
279,015✔
438
  }
439
  return code;
281,663✔
440
}
441

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

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

459
  return code;
165,565✔
460
}
461

462
static int32_t authCreateMultiTable(SAuthCxt* pCxt, SCreateMultiTablesStmt* pStmt) {
30,558,622✔
463
  int32_t code = TSDB_CODE_SUCCESS;
30,558,622✔
464
  SNode*  pNode = NULL;
30,558,622✔
465
  FOREACH(pNode, pStmt->pSubTables) {
67,207,378✔
466
    if (pNode->type == QUERY_NODE_CREATE_SUBTABLE_CLAUSE) {
36,643,011✔
467
      SCreateSubTableClause* pClause = (SCreateSubTableClause*)pNode;
36,642,179✔
468
      code = authObjPrivileges(pCxt, pClause->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
36,642,179✔
469
      if (TSDB_CODE_SUCCESS != code) {
36,640,590✔
470
        break;
164✔
471
      }
472
      code = authObjPrivileges(pCxt, pClause->dbName, NULL, PRIV_TBL_CREATE, PRIV_OBJ_DB);
36,640,426✔
473
      if (TSDB_CODE_SUCCESS != code) {
36,648,756✔
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;
30,566,477✔
489
}
490

491
static int32_t authDropTable(SAuthCxt* pCxt, SDropTableStmt* pStmt) {
2,025,620✔
492
  int32_t code = TSDB_CODE_SUCCESS;
2,025,620✔
493
  if (pStmt->withOpt && !pCxt->pParseCxt->isSuperUser) {
2,025,620✔
494
    return TSDB_CODE_PAR_PERMISSION_DENIED;
260✔
495
  }
496
  SNode* pNode = NULL;
2,025,360✔
497
  FOREACH(pNode, pStmt->pTables) {
4,164,466✔
498
    SDropTableClause* pClause = (SDropTableClause*)pNode;
2,139,106✔
499
    PAR_ERR_RET(checkAuth(pCxt, pClause->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB, NULL));
2,139,106✔
500

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

510
  return code;
2,025,360✔
511
}
512

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

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

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

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

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

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

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

598
  return code;
11,574✔
599
}
600

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

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

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

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

633
  return code;
787✔
634
}
635

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

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

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

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

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

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

715
static int32_t authQuery(SAuthCxt* pCxt, SNode* pStmt) {
291,516,741✔
716
  int32_t code = TSDB_CODE_SUCCESS;
291,516,741✔
717
#ifdef TD_ENTERPRISE
718
  switch (nodeType(pStmt)) {
291,516,741✔
719
    case QUERY_NODE_SET_OPERATOR:
8,444,606✔
720
      return authSetOperator(pCxt, (SSetOperator*)pStmt);
8,444,606✔
721
    case QUERY_NODE_SELECT_STMT:
151,307,268✔
722
      return authSelect(pCxt, (SSelectStmt*)pStmt);
151,307,268✔
723
    case QUERY_NODE_CREATE_ROLE_STMT:
159✔
724
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_CREATE);
159✔
725
    case QUERY_NODE_DROP_ROLE_STMT:
×
726
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_DROP);
×
727
    case QUERY_NODE_CREATE_USER_STMT:
58,725✔
728
      return authSysPrivileges(pCxt, pStmt, PRIV_USER_CREATE);
58,725✔
729
    case QUERY_NODE_DROP_USER_STMT:
22,342✔
730
      return authDropUser(pCxt, (SDropUserStmt*)pStmt);
22,342✔
731
    case QUERY_NODE_DELETE_STMT:
1,687,934✔
732
      return authDelete(pCxt, (SDeleteStmt*)pStmt);
1,687,934✔
733
    case QUERY_NODE_INSERT_STMT:
235,692✔
734
      return authInsert(pCxt, (SInsertStmt*)pStmt);
235,692✔
735
    case QUERY_NODE_CREATE_TABLE_STMT:
6,724,587✔
736
      return authCreateTable(pCxt, (SCreateTableStmt*)pStmt);
6,724,587✔
737
    case QUERY_NODE_CREATE_VIRTUAL_TABLE_STMT:
151,201✔
738
      return authCreateVTable(pCxt, (SCreateVTableStmt*)pStmt);
151,201✔
739
    case QUERY_NODE_CREATE_VIRTUAL_SUBTABLE_STMT:
239,839✔
740
      return authCreateVSubTable(pCxt, (SCreateVSubTableStmt*)pStmt);
239,839✔
741
    case QUERY_NODE_CREATE_MULTI_TABLES_STMT:
30,558,967✔
742
      return authCreateMultiTable(pCxt, (SCreateMultiTablesStmt*)pStmt);
30,558,967✔
743
    case QUERY_NODE_CREATE_STREAM_STMT:
283,841✔
744
      return authCreateStream(pCxt, (SCreateStreamStmt*)pStmt);
283,841✔
745
    case QUERY_NODE_CREATE_TOPIC_STMT:
165,730✔
746
      return authCreateTopic(pCxt, (SCreateTopicStmt*)pStmt);
165,730✔
747
    case QUERY_NODE_DROP_TABLE_STMT:
2,025,620✔
748
      return authDropTable(pCxt, (SDropTableStmt*)pStmt);
2,025,620✔
749
    case QUERY_NODE_DROP_SUPER_TABLE_STMT:
79,277✔
750
      return authDropStable(pCxt, (SDropSuperTableStmt*)pStmt);
79,277✔
751
    case QUERY_NODE_DROP_VIRTUAL_TABLE_STMT:
69,893✔
752
      return authDropVtable(pCxt, (SDropVirtualTableStmt*)pStmt);
69,893✔
753
    case QUERY_NODE_ALTER_TABLE_STMT:
18,239,429✔
754
    case QUERY_NODE_ALTER_SUPER_TABLE_STMT:
755
      return authAlterTable(pCxt, (SAlterTableStmt*)pStmt);
18,239,429✔
756
    case QUERY_NODE_ALTER_VIRTUAL_TABLE_STMT:
368,024✔
757
      return authAlterVTable(pCxt, (SAlterTableStmt*)pStmt);
368,024✔
758
    case QUERY_NODE_SHOW_MODULES_STMT:
102,849✔
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;
102,849✔
773
    case QUERY_NODE_SHOW_USERS_STMT:
120,919✔
774
    case QUERY_NODE_SHOW_USERS_FULL_STMT:
775
      return authSysPrivileges(pCxt, pStmt, PRIV_USER_SHOW);
120,919✔
776
    case QUERY_NODE_SHOW_ROLES_STMT:
159✔
777
      return authSysPrivileges(pCxt, pStmt, PRIV_ROLE_SHOW);
159✔
778
    case QUERY_NODE_SHOW_USER_PRIVILEGES_STMT:
3,715✔
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,715✔
782
    case QUERY_NODE_SHOW_DNODES_STMT:
427,813✔
783
    case QUERY_NODE_SHOW_MNODES_STMT:
784
    case QUERY_NODE_SHOW_QNODES_STMT:
785
    case QUERY_NODE_SHOW_SNODES_STMT:
786
    case QUERY_NODE_SHOW_BNODES_STMT:
787
    case QUERY_NODE_SHOW_ANODES_STMT:
788
    case QUERY_NODE_SHOW_ANODES_FULL_STMT:
789
    case QUERY_NODE_SHOW_XNODES_STMT: // TODO: check auth for xnode resources
790
    case QUERY_NODE_SHOW_XNODE_TASKS_STMT:
791
    case QUERY_NODE_SHOW_XNODE_AGENTS_STMT:
792
    case QUERY_NODE_SHOW_XNODE_JOBS_STMT:
793
      return authSysPrivileges(pCxt, pStmt, PRIV_NODES_SHOW);
427,813✔
794
    case QUERY_NODE_SHOW_CLUSTER_MACHINES_STMT:
5,638✔
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,638✔
799
    case QUERY_NODE_SHOW_TABLES_STMT:
432,852✔
800
    case QUERY_NODE_SHOW_STABLES_STMT:
801
      return authShowTables(pCxt, (SShowStmt*)pStmt);
432,852✔
802
    case QUERY_NODE_SHOW_VTABLES_STMT:
57,080✔
803
      return authShowVtables(pCxt, (SShowStmt*)pStmt);
57,080✔
804
    case QUERY_NODE_SHOW_CREATE_TABLE_STMT:
80,620✔
805
    case QUERY_NODE_SHOW_CREATE_VTABLE_STMT:
806
    case QUERY_NODE_SHOW_CREATE_STABLE_STMT:
807
      return authShowCreateTable(pCxt, (SShowCreateTableStmt*)pStmt);
80,620✔
808
    case QUERY_NODE_SHOW_CREATE_VIEW_STMT:
×
809
      return authShowCreateView(pCxt, (SShowCreateViewStmt*)pStmt);
×
810
    case QUERY_NODE_CREATE_VIEW_STMT:
18,472✔
811
      return authCreateView(pCxt, (SCreateViewStmt*)pStmt);
18,472✔
812
    case QUERY_NODE_DROP_VIEW_STMT:
×
813
      return authDropView(pCxt, (SDropViewStmt*)pStmt);
×
814
    case QUERY_NODE_CREATE_INDEX_STMT:
11,574✔
815
      return authCreateIndex(pCxt, (SCreateIndexStmt*)pStmt);
11,574✔
816
    case QUERY_NODE_DROP_INDEX_STMT:
3,234✔
817
      return authDropIndex(pCxt, (SDropIndexStmt*)pStmt);
3,234✔
818
    case QUERY_NODE_SHOW_INDEXES_STMT:
4,276✔
819
      return authShowIndexes(pCxt, (SShowStmt*)pStmt);
4,276✔
820
    case QUERY_NODE_CREATE_TSMA_STMT:
787✔
821
      return authCreateTsma(pCxt, (SCreateTSMAStmt*)pStmt);
787✔
822
    case QUERY_NODE_DROP_TSMA_STMT:
×
823
      return authDropTsma(pCxt, (SDropTSMAStmt*)pStmt);
×
824
    case QUERY_NODE_CREATE_RSMA_STMT:
109,515✔
825
      return authCreateRsma(pCxt, (SCreateRsmaStmt*)pStmt);
109,515✔
826
    case QUERY_NODE_DROP_RSMA_STMT:
2,205✔
827
      return authDropRsma(pCxt, (SDropRsmaStmt*)pStmt);
2,205✔
828
    case QUERY_NODE_ALTER_RSMA_STMT:
19,845✔
829
      return authObjPrivileges(pCxt, ((SAlterRsmaStmt*)pStmt)->dbName, ((SAlterRsmaStmt*)pStmt)->rsmaName,
19,845✔
830
                               PRIV_CM_ALTER, PRIV_OBJ_RSMA);
831
    case QUERY_NODE_SHOW_CREATE_RSMA_STMT:
2,205✔
832
      return authShowCreateRsma(pCxt, (SShowCreateRsmaStmt*)pStmt);
2,205✔
833
    case QUERY_NODE_CREATE_DATABASE_STMT:
1,307,185✔
834
      return authSysPrivileges(pCxt, pStmt, PRIV_DB_CREATE);
1,307,185✔
835
    case QUERY_NODE_BALANCE_VGROUP_STMT:
11,527✔
836
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_BALANCE);
11,527✔
837
    case QUERY_NODE_BALANCE_VGROUP_LEADER_DATABASE_STMT:
2,185✔
838
    case QUERY_NODE_BALANCE_VGROUP_LEADER_STMT:
839
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_BALANCE_LEADER);
2,185✔
840
    case QUERY_NODE_MERGE_VGROUP_STMT:
×
841
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_MERGE);
×
842
    case QUERY_NODE_SPLIT_VGROUP_STMT:
16,644✔
843
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_SPLIT);
16,644✔
844
    case QUERY_NODE_REDISTRIBUTE_VGROUP_STMT:
44,428✔
845
      return authSysPrivileges(pCxt, pStmt, PRIV_VG_REDISTRIBUTE);
44,428✔
846
    case QUERY_NODE_CREATE_FUNCTION_STMT:
32,103✔
847
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_CREATE);
32,103✔
848
    case QUERY_NODE_DROP_FUNCTION_STMT:
23,756✔
849
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_DROP);
23,756✔
850
    case QUERY_NODE_SHOW_FUNCTIONS_STMT:
25,217✔
851
      return authSysPrivileges(pCxt, pStmt, PRIV_FUNC_SHOW);
25,217✔
852
    case QUERY_NODE_GRANT_STMT:
567,050✔
853
      return authGrant(pCxt, (SGrantStmt*)pStmt);
567,050✔
854
    case QUERY_NODE_REVOKE_STMT:
408,467✔
855
      return authRevoke(pCxt, (SRevokeStmt*)pStmt);
408,467✔
856
    case QUERY_NODE_CREATE_DNODE_STMT:
272,975✔
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);
272,975✔
863
    case QUERY_NODE_DROP_DNODE_STMT:
89,357✔
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);
89,357✔
870
    case QUERY_NODE_ALTER_DATABASE_STMT:
176,640✔
871
      return authObjPrivileges(pCxt, ((SAlterDatabaseStmt*)pStmt)->dbName, NULL, PRIV_CM_ALTER, PRIV_OBJ_DB);
176,640✔
872
    case QUERY_NODE_DROP_DATABASE_STMT:
1,078,351✔
873
      return authObjPrivileges(pCxt, ((SDropDatabaseStmt*)pStmt)->dbName, NULL, PRIV_CM_DROP, PRIV_OBJ_DB);
1,078,351✔
874
    case QUERY_NODE_USE_DATABASE_STMT:
2,043,102✔
875
      return authObjPrivileges(pCxt, ((SAlterDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_USE, PRIV_OBJ_DB);
2,043,102✔
876
    case QUERY_NODE_FLUSH_DATABASE_STMT:
1,724,599✔
877
      return authObjPrivileges(pCxt, ((SFlushDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_FLUSH, PRIV_OBJ_DB);
1,724,599✔
878
    case QUERY_NODE_COMPACT_DATABASE_STMT:
26,575✔
879
      return authObjPrivileges(pCxt, ((SCompactDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_COMPACT, PRIV_OBJ_DB);
26,575✔
880
    case QUERY_NODE_TRIM_DATABASE_STMT:
8,024✔
881
      return authObjPrivileges(pCxt, ((STrimDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_TRIM, PRIV_OBJ_DB);
8,024✔
882
    case QUERY_NODE_ROLLUP_DATABASE_STMT:
9,555✔
883
      return authObjPrivileges(pCxt, ((SRollupDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_ROLLUP, PRIV_OBJ_DB);
9,555✔
884
    case QUERY_NODE_SCAN_DATABASE_STMT:
94✔
885
      return authObjPrivileges(pCxt, ((SScanDatabaseStmt*)pStmt)->dbName, NULL, PRIV_DB_SCAN, PRIV_OBJ_DB);
94✔
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
7,569✔
889
      return authShowUsage(pCxt, (SShowStmt*)pStmt);
7,569✔
890
      // check in mnode
891
    case QUERY_NODE_SHOW_VGROUPS_STMT:
599,702✔
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;
599,702✔
898
    default:
60,977,795✔
899
      break;
60,977,795✔
900
  }
901
#endif
902
  return code;
60,977,795✔
903
}
904

905
int32_t authenticate(SParseContext* pParseCxt, SQuery* pQuery, SParseMetaCache* pMetaCache) {
251,994,009✔
906
  SAuthCxt cxt = {.pParseCxt = pParseCxt, .pMetaCache = pMetaCache, .errCode = TSDB_CODE_SUCCESS};
251,994,009✔
907
  return authQuery(&cxt, pQuery->pRoot);
251,998,215✔
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