• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 442
  • Last Modified:

MySQL Workbench Column level rights

I am using MySQL Workbench 6.0. When I go into Users And privileges then to the user. All it shows is Custom under Administrative Rights but nothing about which column or table it effects (which rights the user has at the column level). Is there a different place to look for this?
Thanks
MySqlRights.PNG
0
CityInfoSys
Asked:
CityInfoSys
1 Solution
 
Dan CraciunIT ConsultantCommented:
I think what you want should be in the "Schema privileges" tab.
If you want to see table permissions, I don't know if that's available in Workbench.

If you can install it, phpmyadmin has a very easy way to create/see table based user permissions.

HTH,
Dan
0
 
CityInfoSysAuthor Commented:
I'll give phpmyadmin a try.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now