Whether you're taking your first steps with Kubernetes or you're an experienced practitioner looking to sharpen your skills, our Amazon EKS workshop series delivers practical, real-world experience that moves you forward. Learn directly from AWS solutions architects and EKS specialists through hands-on sessions designed to build your confidence with Kubernetes. Register now and start building with Amazon EKS!
Aurora Row level and column level security
A customer is currently using MySQL and are using a view with a WHERE clause to prevent certain users from seeing rows.
Do we have anything within Aurora that provides row and column security, or would views still be needed for this?
- Tags
- Amazon Aurora
- Language
- English
- Newest
- Most votes
- Most comments
You can restrict column level access to users in Aurora and MySQL using below statement. But there is so easy option to restrict row level access other can using views.
GRANT SELECT(ChannelId, VideoId) on RealEstate TO user1; <== grants access only on columns ChannelId and VideoId
Reference: http://dev.mysql.com/doc/refman/5.6/en/grant.html#grant-column-privileges
Relevant content
- asked 2 years ago
