Aurora Row level and column level security
0
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?
1回答
- 新しい順
- 投票が多い順
- コメントが多い順
0
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
回答済み 7年前
関連するコンテンツ
- 質問済み 6年前
AWS公式更新しました 3年前- AWS公式更新しました 1年前
