MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?

by

Mysql doesn’t natively support row level security on tables. However, you can sort of implement it with views. So, just create a view on your table that exposes only the rows you want a given client to see. Then, only provide that client access to those views, and not the underlying tables.

See http://www.sqlmaestro.com/resources/all/row_level_security_mysql/

More Related Contents:

  1. How to select the nth row in a SQL database table?
  2. What does character set and collation mean exactly?
  3. Implementing Comments and Likes in database
  4. Auto Generate Database Diagram MySQL [closed]
  5. MySQL stored procedures use them or not to use them
  6. In SQL, is it OK for two tables to refer to each other?
  7. Modeling Product Variants
  8. How to design a multi tenant mysql database
  9. DOs and DONTs for Indexes [closed]
  10. Does mysql have the equivalent of Oracle’s “analytic functions”?
  11. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  12. What resources exist for Database performance-tuning? [closed]
  13. Difference between two table structure
  14. Proper database model for a user feedback system (an interesting case)
  15. Strings as Primary Keys in MYSQL Database [closed]
  16. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  17. Inventory management with stock options
  18. In SQL Server how to get the count of child if both parent and child are available [closed]
  19. MyISAM versus InnoDB [closed]
  20. What is the ideal data type to use when storing latitude / longitude in a MySQL database?
  21. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  22. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  23. How to increase MySQL connections(max_connections)?
  24. MySQL: LAST_INSERT_ID() returns 0
  25. Calculating a Moving Average MySQL?
  26. Can I launch a trigger on select statement in mysql?
  27. How do you write a case insensitive query for both MySQL and Postgres?
  28. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  29. How to store data with dynamic number of attributes in a database
  30. MySQL Relationships

Leave a Comment