Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2015
    Posts
    2

    Unanswered: protect table rows against unauthorized changes

    hi,
    I want to do some changes in mysql db code to protect table rows from unauthorized changes in table rows, so how can do this? where should I start?

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    with out any real info on what you are attempting to do and what version, I would just say "start here: http://dev.mysql.com/doc/refman/5.7/en/security.html
    Dave

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    1. First of all, determine in your own mind what you want to accomplish.
    2. If you can do some or all of what you want to accomplish, then do it.
    3. If there are parts that you can't do, hire someone who can help you.
    4. If there are still parts that need to be done, repeat this cycle.


    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    There are no code changes required for this. You need to, as has been mentioned above, determine who should have access to what data. When you have this you can then grant specific access to different users (search for GRANT syntax in MySQL). For example, user1 has access to table1, user2 has insert and select access on table1. Then you simply grant

    GRANT SELECT ON table1 TO user1;
    GRANT SELECT, INSERT ON table1 TO user2;
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'm pretty sure that MySQL can use GRANT to manage access to columns, but the OP (original poster) wanted to control access to rows. If you can use the MySQL GRANT statement to control access to rows, I'd love to see a demonstration!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  6. #6
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    MySQL does not provide ROW LEVEL access as exists in Oracle, but you can perform something similar by creating a VIEW on the subset of data you want to grant access to and then GRANT SELECT access on that view.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  7. #7
    Join Date
    Jan 2015
    Posts
    2
    thanks for your guidances,
    in this project whenever are created tables, automatically insert a transparent column to each table that hold MAC value for each rows.
    actually i want to implement like "transparent data encryption" (TDE) that exist in oracle.
    for do this how can i start?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •