Announcement

Announcement Module
Collapse
No announcement yet.

How to avoid security violation at table level

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

  • How to avoid security violation at table level

    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

  • #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