Get Role Members and Audits

Dremio University
1

We have installed dremio software version 22.0.0 enterprise edition. Created few roles and users. By using Dremio to get the member list of the role

it returns

    "errorMessage": "HTTP 404 Not Found",
    "moreInfo": ""
}

Curl command

curl --location --request GET 'http://localhost:9047/api/v3/role/<role_id>/members' \
--header 'Content-Type: application/json' \
--header 'Authorization: _dremionhvcsp6uuuchcs8v60a01k85cj'
{"errorMessage":"HTTP 404 Not Found","moreInfo":""}%

Please note that we have used the role_id column from sys.roles table as id in above REST API

Also … We need the sql query or REST API to fetch the query history from Dremio.

Can anyone please help us to resolve the above queries

2

@anupamkakade Can you kindly try to take out the “members” keyword and retry, something like below

  • From Postman
localhost:9047/api/v3/role/e125df54-b18d-4335-a2b6-937a3987c553
  • From Curl
curl --location --request GET 'localhost:9047/api/v3/role/<role_id>' \
--header 'Authorization: _dremioxxxxxxxxxxxxxxx \
--header 'Content-Type: application/json' \
--data-raw '{
	"sql": "SELECT TeamName, DremioFolderName, BucketName FROM localmysql.qa.SecTeam"
}'
3

Hi Balaji,
Thanks for your response. The above API returns only the role info.
I was looking for the API which returns the members of the role

4

@anupamkakade Was able to reproduce and checking internally, will keep you posted

1 Like
5

Is there any updates on this issue?

6

@ssol

Only a V2 end point is available,

http://localhost:9047/apiv2/role/{role ID}/member/

This does not list members if the role is an external role