{"version":"1.0","width":"100%","url":"https://htn20190109.hatenablog.com/entry/2019/01/23/083221","author_name":"HTN20190109","blog_url":"https://htn20190109.hatenablog.com/","blog_title":"HTN20190109\u306e\u65e5\u8a18","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2019%2F01%2F23%2F083221\" title=\"\u30ed\u30fc\u30eb\u4f5c\u6210 - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/HTN20190109/","height":"190","categories":["DB"],"provider_url":"https://hatena.blog","description":"Oracle create role role1;grant select any table to role1; MySQL (8.0)create database app_db; CREATE ROLE 'app_developer', 'app_read', 'app_write'; GRANT ALL ON app_db.* TO 'app_developer';GRANT SELECT ON app_db.* TO 'app_read';GRANT INSERT, UPDATE, DELETE ON app_db.* TO 'app_write'; CREATE USER 'dev\u2026","title":"\u30ed\u30fc\u30eb\u4f5c\u6210","type":"rich","published":"2019-01-23 08:32:21"}