Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

show users privileges for specific databases #2212

Closed
dgolja opened this issue Apr 9, 2015 · 5 comments
Closed

show users privileges for specific databases #2212

dgolja opened this issue Apr 9, 2015 · 5 comments
Labels
area/queries difficulty/medium Resolving this issue should take up to a week
Milestone
Longer term

Comments

@dgolja
Copy link
Contributor

dgolja commented Apr 9, 2015

Since v0.9.0.RC* users are globally defined, so it means we will need a way how to expose the user privileges on a database level. The current show users command only lists the users, without the database rights.

Honestly not sure what would be the best syntax. Maybe SHOW GRANTS FOR user ? There is a similar command in the SQL world (https://dev.mysql.com/doc/refman/5.0/en/show-grants.html).
@beckettsean beckettsean added this to the Next Point Release milestone Apr 14, 2015
@beckettsean beckettsean added status/help-wanted difficulty/medium Resolving this issue should take up to a week labels Apr 14, 2015
@geodimm geodimm mentioned this issue May 4, 2015
Merged
@dgolja
Copy link
Contributor Author

dgolja commented May 16, 2015

based on the feedback I will go ahead an implement the SHOW GRANTS FOR user syntax :)

@dgolja dgolja mentioned this issue May 24, 2015
Merged
@gunnaraasen gunnaraasen mentioned this issue Jun 3, 2015
Closed
@beckettsean beckettsean modified the milestones: Next Point Release, Longer term Aug 6, 2015
@jtblin
Copy link

jtblin commented Nov 17, 2015

This one can be closed no?

@beckettsean
Copy link
Contributor

yes, good catch, @jtblin!

@rca
Copy link

rca commented Mar 8, 2016

Is there a way to list all the users with privileges on a single database?

The command SHOW PRIVILEGES FOR user allows me to see what databases a user can access; I'd like to see what users have been given access to a database, for instance SHOW PRIVILEGES ON db.

@krishnakanthpps
Copy link

+1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area/queries difficulty/medium Resolving this issue should take up to a week
Projects
None yet
Milestone
Longer term
Development

No branches or pull requests
5 participants
@rca @jtblin @dgolja @krishnakanthpps @beckettsean