winggundamth/gist:f836e113522a9710b54c88de985c83bc

Created January 6, 2017 14:12

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/winggundamth/f836e113522a9710b54c88de985c83bc.js"></script>
Save winggundamth/f836e113522a9710b54c88de985c83bc to your computer and use it in GitHub Desktop.

Download ZIP

Create InfluxDB database and non-admin user then grant all permission to that user

Raw

gistfile1.txt

	CREATE USER "username" WITH PASSWORD 'password'
	CREATE DATABASE "database"
	GRANT ALL ON "username" TO "database"

Patrick-Shih commented Sep 28, 2017

Your grant syntax is wrong. It should be

GRANT [READ,WRITE,ALL] ON <database_name> TO

allamiro commented Nov 15, 2018

I think this should be

GRANT ALL ON "database" TO "username"

Owned67 commented Dec 5, 2023

`> use server
Using database server

CREATE USER "Owned67" WITH PASSWORD '123456'
GRANT ALL ON "Owned67" to server`
ERR: user not found

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment