MySQL Forums
Forum List  »  MySQL Workbench

Re: Permissions
Posted by: Mike Lischke
Date: March 14, 2013 03:06AM

Jay,

there are roles in WB but since MySQL doesn't support roles WB only collects a number of permissions under each role and applies them when you assign a role to a user (see Users and Privileges -> Server Access Management -> Administrative Roles). Under Schema Privileges you can assign individual rights to one or more schemas for each user/host combination. However there's no setting for other db objects like tables (even though MySQL supports this). You have to go with grant statements yourself in these cases.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/

Options: ReplyQuote


Subject
Views
Written By
Posted
817
March 12, 2013 08:43AM
438
March 12, 2013 10:40AM
Re: Permissions
540
March 14, 2013 03:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.