Crimson Wings's Profile User Rating: -----

Reputation: 13 Tradesman
Group:
Contributors
Active Posts:
215 (0.11 per day)
Joined:
11-July 09
Profile Views:
5,814
Last Active:
User is offline Sep 22 2013 02:50 PM
Currently:
Offline

Previous Fields

Country:
BO
OS Preference:
Mac
Favorite Browser:
Chrome
Favorite Processor:
Intel
Favorite Gaming Platform:
Playstation
Your Car:
Who Cares
Dream Kudos:
25

Latest Visitors

Icon   Crimson Wings When you REALLY like something, you should be able to learn about it on your own.

Posts I've Made

  1. In Topic: Is it a good idea to create different MySQL users for different tasks?

    Posted 19 Aug 2013

    Yeah the thing is I'm not really giving everyone permissions haha. Man maybe I need to find a way to express myself better. :P/> Just the MySQL user(s) that will do the queries in behalf of the employees. Think of a MySQL user that I will grant "ALL PERMISSIONS" versus three different MySQL users that will have "SELECT', "INSERT", and "UPDATE" permissions separately, like.

    dbuser_readonly. SELECT permissions.
    dbuser_update. UPDATE permissions only.
    dbuser_insert. INSERT permissions only.

    In that way my employees who only have read only permissions would make the system issue their queries via the dbuser_readonly MysQL user.

    Still I think you're right though. I just never heard of a system that has multiple MySQL users to begin with.
  2. In Topic: Is it a good idea to create different MySQL users for different tasks?

    Posted 19 Aug 2013

    View Postandrewsw, on 19 August 2013 - 06:04 PM, said:

    You have exhausted my knowledge on this subject (and I'm a little confused) but:

    Quote

    I have figured out my permissions system, I just don't know if the managing MySQL users should be many or just one MySQL user with all permissions in the database.

    you should limit the number of people who have all permissions :surrender:/> so this, in my mind, necessitates creating at least 3-4 different roles. Good luck.


    Yeah, that's what I'm thinking, which is why I should have MySQL users with different permissions rather than one "master" MySQL user. My Employees themselves won't really have much "power" at all, but the underlying MySQL users they all share is what is worrying me. :)

    That being said, you answered my question haha. Thanks. Hopefully more people will have more imput on this.
  3. In Topic: Is it a good idea to create different MySQL users for different tasks?

    Posted 19 Aug 2013

    I'm actually talking about the MySQL users in the back-end.

    The first app I'm building is to keep track of what actions an employee does with an external app. The thing is not all employees have permissions to update the external up with new data. Some of them will have their "account" in our company but they can only view their own personal data - to manage these users I'd like to create a back-end MySQL user with read-only permissions. Then for users that update the external app I need to log their actions in a new table - for this I want to have a MySQL user that has insertion rights only. I'm mostly talking about the database design and it's users rather than its front-end

    I have figured out my permissions system, I just don't know if the managing MySQL users should be many or just one MySQL user with all permissions in the database.

    Gah, I don't know if I'm being clear haha, but think of actual users who have their accounts as "Employees" and the MySQL users as the actual users only MySQL sees in the server.

My Information

Member Title:
D.I.C Head
Age:
22 years old
Birthday:
May 20, 1992
Gender:
Location:
La Paz, Bolivia.
Interests:
Programming, nature, music making, graphic design, metal music, music in general. CS.
Full Name:
Andy Ibanez
Years Programming:
7
Programming Languages:
Objective-C, (X)HTML (in all its variations), CSS, PHP, C++, C#, Python.

Contact Information

E-mail:
Click here to e-mail me
MSN:
MSN  vermillion@projectawings.com
Website URL:
Website URL  http://www.andyibanez.com
Facebook:
http://facebook.com/Atanacross
Twitter:
andyibanezk

Comments

Page 1 of 1
  1. Photo

    Creecher Icon

    02 Mar 2011 - 06:35
    Thanks, yours seems nice too. 'metal music' pretty much puts it all in one :)
  2. Photo

    Sergio Tapia Icon

    26 Feb 2011 - 16:26
    Saludos a vos tambien! Pense que era el unico boliviano aca. :D Soy de Santa Cruz y vos?
Page 1 of 1