LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
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, 01:00 PM   #1
richinsc
Member
 
Registered: Mar 2007
Location: Utah
Distribution: Gentoo Linux (3.0.6-gentoo)
Posts: 222

Rep: Reputation: 31
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, 02:25 PM   #2
richinsc
Member
 
Registered: Mar 2007
Location: Utah
Distribution: Gentoo Linux (3.0.6-gentoo)
Posts: 222

Original Poster
Rep: Reputation: 31
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, 08:54 PM   #3
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.5, Centos 5.10
Posts: 16,247

Rep: Reputation: 2025Reputation: 2025Reputation: 2025Reputation: 2025Reputation: 2025Reputation: 2025Reputation: 2025Reputation: 2025Reputation: 2025Reputation: 2025Reputation: 2025
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 09:19 PM
LXer: Visual MySQL Database Design in MySQL Workbench LXer Syndicated Linux News 0 06-12-2008 07:00 PM
mysql - can't access mysql database as root yogaboy Linux - Software 5 12-28-2006 06:58 AM
Writing an app that uses a mysql database without installing mysql server? QtCoder Programming 4 08-09-2004 02:43 PM
MYSQL help - mysql database missing eloviyandhi Linux - Software 1 03-20-2004 09:20 PM


All times are GMT -5. The time now is 03:07 AM.

Main Menu
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