•  

Announcement

Announcement Module
Collapse
No announcement yet.

How to avoid security violation at table level

Page Title Module
Move Remove Collapse
Conversation Detail Module
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to avoid security violation at table level

    #1
    Hello all,

    I have a huge table in which data of three clients are stored. I want to restrict one client to see the data of other two inorder to avoid security violation.
    Does Mysql has any facility to do this at table level?

    Please give me suggestions.


    Regards
    Sus Moh
    Tags: None
  • #2
    You can add different access rights to different columns (see mysql.columns_priv table), but it's not possible to have different access rights to different rows in one table (at least using built-in MySQL features).
    Maybe you can add some extra level between clients and MySQL? Like some script, which will select only those rows which belong to specific client.

    Comment

    • #3
      Thanks, for your timely and prompt suggestion.

      Regards
      sus moh

      Comment

      Working...
      X