LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



Reply
 
Search this Thread
Old 09-25-2008, 02:00 PM   #1
richinsc
Member
 
Registered: Apr 2007
Location: Utah
Distribution: Gentoo Linux (3.0.6-gentoo)
Posts: 222

Rep: Reputation: 32
Read Only MySQL Database


I was wondering what would be the minimum grant options to allow for read only access to a mysql database. I have a member of management who insists on using MS Access to link to our mysql database. I have built a PHP front end that give people the access that he needs but still they insist on using mysql connector and MS Access.

I can only thing that they would need SELECT access or maybe just USEAGE Access. Any help would be greatly appreciated...

Stupid Microsoft Users
 
Old 09-25-2008, 03:25 PM   #2
richinsc
Member
 
Registered: Apr 2007
Location: Utah
Distribution: Gentoo Linux (3.0.6-gentoo)
Posts: 222

Original Poster
Rep: Reputation: 32
I gave the user USAGE only access but that was to low. After reading on-line and finding vague description I found out that USAGE is equal to no privileges. So at that point I granted SELECT Permissions and user is able to read all entries from database. I figured this is what I needed to do but I didn't know if MS Access would dink around my permissions and kill DB. Connected MS Access to MySQL using OBDC MySQL connector.
 
Old 09-25-2008, 09:54 PM   #3
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.6, Centos 5.10
Posts: 16,324

Rep: Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041
That should be fine. Only the dba (mysql root) or the schema owner is able to change perms for other users.
Have you seen this: http://dev.mysql.com/doc/refman/5.0/en/privileges.html
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i copt the MYSQL Database to a other server (Database) halvorls Linux - Server 3 07-27-2008 10:19 PM
LXer: Visual MySQL Database Design in MySQL Workbench LXer Syndicated Linux News 0 06-12-2008 08:00 PM
mysql - can't access mysql database as root yogaboy Linux - Software 5 12-28-2006 07:58 AM
Writing an app that uses a mysql database without installing mysql server? QtCoder Programming 4 08-09-2004 03:43 PM
MYSQL help - mysql database missing eloviyandhi Linux - Software 1 03-20-2004 10:20 PM


All times are GMT -5. The time now is 09:23 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration