# Create role, grant to user, replicate, verify
admin 'CREATE USER bob'
admin 'CREATE ROLE editors'
admin 'GRANT editors TO bob'
replicate
---
version: 2
query 'FROM system::roles FILTER {name == "editors"}'
---
+---------+-----------+
| id | name |
+---------+-----------+
| 16385 | editors |
+---------+-----------+
query 'FROM system::granted_roles'
---
+----------------------------------------+-----------+
| identity | role_id |
+----------------------------------------+-----------+
| 00000000-03e8-7169-89ff-3f1492354ad7 | 16385 |
+----------------------------------------+-----------+