Get Role Members and Audits

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

@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"
}'

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

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

1 Like