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

Reputation: 13 Tradesman
Group:
Contributors
Active Posts:
215 (0.12 per day)
Joined:
11-July 09
Profile Views:
5,562
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.
  4. In Topic: Check If A Time Falls Between A Range?

    Posted 11 Jun 2012

    Thanks both.
    I ended up using Dormilich's solution because the info has to be compared before being saved into the database.
    Regardless, both were helpful and I have 1+'d both. So thanks again!
  5. In Topic: DriverManager.getConnection() Not Working.

    Posted 22 May 2012

    View Postpbl, on 21 May 2012 - 11:01 PM, said:

    View PostCrimson Wings, on 21 May 2012 - 04:28 PM, said:

    DriverManager.getConnection() is throwing an SQLException everytime and I'm not sure of what I could try.

    Which Exception ? We are supposed to guess it ?


    Like I said, an SQLException. Or are there any other specialized SQL-related exceptions to begin with that I don't know about?
    At any rate I was told I could use .getMessage() (I had no idea we could use that method before to get more "in-depth" info in the exception) in thrown exceptions and I did that, read the message (which was something in the lines of "missing driver") and pretty much solved my problem. So it's all good now.

My Information

Member Title:
D.I.C Head
Age:
21 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