Solved

MySQL Workbench Column level rights

Posted on 2014-03-10
2
398 Views
Last Modified: 2014-03-11
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
Comment
Question by:CityInfoSys
2 Comments
 
LVL 34

Accepted Solution

by:
Dan Craciun earned 500 total points
Comment Utility
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
 
LVL 1

Author Comment

by:CityInfoSys
Comment Utility
I'll give phpmyadmin a try.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now