Querying Table Users (Discarded)¶

Function¶

This API is used to query users who have permission to access the specified table or column in the table.

Note

This API has been discarded and is not recommended.

URI¶

URI format
GET /v1.0/{project_id}/databases/{database_name}/tables/{table_name}/users

Parameter description

**Table 1** URI parameters¶
Parameter	Mandatory	Description
project_id	Yes	Project ID, which is used for resource isolation. For details about how to obtain its value, see Obtaining a Project ID.
database_name	Yes	Name of the database where the table to be queried resides.
table_name	Yes	Name of a table that is to be queried.

Request¶

None

Response¶

**Table 2** Response parameters¶
Parameter	Mandatory	Type	Description
is_success	No	Boolean	Whether the request is successfully executed. Value true indicates that the request is successfully executed.
message	No	String	System prompt. If execution succeeds, the parameter setting may be left blank.
privileges	No	Array <Objects>	Permission information. For details, see Table 3.

**Table 3** **privileges** parameters¶
Parameter	Mandatory	Type	Description
is_admin	No	Boolean	Determines whether a user is an administrator. The value false indicates that the user is not an administrator, and the value true indicates that the user is an administrator.
object	No	String	Objects on which a user has permission. If the object is in the format of databases.Database name.tables.Table name, the user has permission on the database. If the object is in the format of databases.Database name.tables.Table namecolumns.Column name, the user has permission on the table.
privileges	No	Array<String>	Permission of the user on the object.
user_name	No	String	Name of the user who has the permission.

Example Request¶

None

Example Response¶

{
  "is_success": true,
  "message": "",
  "privileges": [
    {
      "is_admin": false,
      "object": "databases.dsstest.tables.csv_par_table",
      "privileges": [
        "SELECT"
      ],
      "user_name": "tent2"
    },
    {
      "is_admin": true,
      "object": "databases.dsstest.tables.csv_par_table",
      "privileges": [
        "ALL"
      ],
      "user_name": "tent4"
    }
  ]
}

Note

If an error occurs when this API is invoked, the system does not return the result similar to the preceding example, but returns the error code and error information. For details, see Error Codes.

last updated: 2024-12-10 15:25 UTC - commit: 9e0ebe18fe0b43010decd2c132af9f5362beb29e