Skip to content

Instantly share code, notes, and snippets.

@mpchadwick

mpchadwick/magento-admin-users-and-roles.sql

Created May 8, 2017 20:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mpchadwick/273b7019f7038a7f172b73c76d9e6254 to your computer and use it in GitHub Desktop.
Save mpchadwick/273b7019f7038a7f172b73c76d9e6254 to your computer and use it in GitHub Desktop.
Download ZIP
magento-admin-users-and-roles.sql
Raw
magento-admin-users-and-roles.sql
SELECT
firstname,
lastname,
email,
username,
au2.role_name
FROM admin_user
INNER JOIN admin_role au1
ON admin_user.user_id = au1.user_id
INNER JOIN admin_role au2
ON au1.parent_id = au2.role_id
ORDER BY role_name ASC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment