Privileges for "show databases" query over HTTP API

#1

Hello all,

Not sure if this is a bug or a feature so I’m posting it here before logging an issue on Github.

Enable “SHOW DATABASES” results for read/write users.

Any user besides the Admin user receives the message:
{"error":"error authorizing query: write_user not authorized to execute statement 'SHOW DATABASES', requires admin privilege"}

Is there a reason a user with read/write privileges are not able to see the databases they have access to?

My situation is that I’m creating a connector to InfluxDB (from Tableau) and I need to retrieve the list of databases to populate for the users to select from. Or is there another way to get a list of databases for a read/write (non-admin) user?

cheers,
Tag

#2

@tagyoureit Looks like this is fixed in master and will be in the 1.3 release. Hope that helps!

#3

Awesome! I tried to search for the issue but clearly missed it. Thanks so much!
Russ