Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Mr. McFriendly
Lv 7
Mr. McFriendly asked in Computers & InternetProgramming & Design · 6 years ago

MySQL: In a MySQL, is it possible to grant permissions at row level.?

For example if I wanted to grant a user write access but only to one row within a table

Update:

*In MySQL

3 Answers

Relevance
  • Daniel B
    Lv 7
    6 years ago
    Favorite Answer

    MySQL doesn't have row level security built in like some databases, but you can simulate it by using views and triggers...

    https://www.sqlmaestro.com/resources/all/row_level...

  • ?
    Lv 6
    6 years ago

    I could be wrong, but I think you can give people write access to a table, but not a row.

  • John
    Lv 7
    6 years ago

    using stored procedure instead of table and grant write access to the procedure

Still have questions? Get your answers by asking now.