You can create a role with permissions associated with it, and then grant users that role. This way you don't have to repeatedly grant the

11/7/2016 - 7:17 PM

You can create a role with permissions associated with it, and then grant users that role. This way you don't have to repeatedly grant the

You can create a role with permissions associated with it, and then grant users that role. This way you don't have to repeatedly grant the same set of privileges to many users. THIS APPARENTLY ISN'T SUPPORTED IN MYSQL. Line 1 shows how to CREATE a ROLE, and line 3 shows how to GRANT that role to a user.

CREATE ROLE and GRANT ROLE MS.mysql

CREATE ROLE SalesClerk;

GRANT SalesClerk to mcmahonk;

Cacher is the code snippet organizer for pro developers

We empower you and your team to get more done, faster

You can create a role with permissions associated with it, and then grant users that role. This way you don't have to repeatedly grant the