symion5464
10/14/2022, 12:27 AMsymion5464
10/14/2022, 12:28 AM[
{
"ID": 1,
"name": "Readonly",
"rules": {
"reader": ["alerts", "views"],
"writer": [],
"manager": []
}
},
{
"ID": 2,
"name": "Basic",
"parent_role_ids": [1],
"rules": {
"reader": [],
"writer": ["alerts", "views"],
"manager": []
}
},
{
"ID": 3,
"name": "Admin",
"parent_role_ids": [2],
"rules": {
"reader": [],
"writer": [],
"manager": ["alerts", "views"]
}
}
]
symion5464
10/14/2022, 12:28 AMsymion5464
10/14/2022, 12:28 AMJake
10/14/2022, 12:29 AMJake
10/14/2022, 12:29 AMJake
10/14/2022, 12:30 AMJake
10/14/2022, 12:30 AMsymion5464
10/14/2022, 12:32 AMsymion5464
10/14/2022, 12:32 AMspicedb=# select * from relation_tuple;
namespace | object_id | relation | userset_namespace | userset_object_id | userset_relation | created_xid | deleted_xid
-----------+-----------+----------+-------------------+-------------------+------------------+-------------+---------------------
resource | alerts | reader | role | readonly | member | 787 | 9223372036854775807
(1 row)
spicedb=# select * from relation_tuple_transaction;
timestamp | xid | snapshot
----------------------------+-----+----------
1970-01-01 00:00:00 | 1 | 1:1:
2022-10-14 00:26:23.658744 | 785 | 785:785:
2022-10-14 00:27:37.423208 | 787 | 787:787:
symion5464
10/14/2022, 12:33 AMJake
10/14/2022, 12:33 AMJake
10/14/2022, 12:34 AMsymion5464
10/14/2022, 12:34 AMsymion5464
10/14/2022, 12:36 AMJake
10/14/2022, 12:36 AM--log-level debug
symion5464
10/14/2022, 12:37 AMJake
10/14/2022, 12:37 AMsymion5464
10/14/2022, 12:37 AMsymion5464
10/14/2022, 1:12 AMsymion5464
10/14/2022, 1:13 AMcompose-spicedb-1 | {"level":"debug","module":"pgx","args":["resource","alerts","reader","role","readonly","member","resource","views","reader","role","readonly","member"],"commandTag":"SU5TRVJUIDAgMg==","pid":86,"sql":"INSERT INTO relation_tuple (namespace,object_id,relation,userset_namespace,userset_object_id,userset_relation) VALUES ($1,$2,$3,$4,$5,$6),($7,$8,$9,$10,$11,$12)","time":2.139288,"time":"2022-10-14T00:56:57Z","message":"Exec"}
symion5464
10/14/2022, 1:14 AMJake
10/14/2022, 1:14 AMsymion5464
10/14/2022, 1:15 AMsymion5464
10/14/2022, 1:15 AMsymion5464
10/14/2022, 1:16 AMspicedb=# select * from relation_tuple;
namespace | object_id | relation | userset_namespace | userset_object_id | userset_relation | created_xid | deleted_xid
-----------+-----------+----------+-------------------+-------------------+------------------+-------------+---------------------
resource | alerts | reader | role | readonly | member | 787 | 9223372036854775807
resource | views | reader | role | readonly | member | 787 | 9223372036854775807
Jake
10/14/2022, 1:19 AMJake
10/14/2022, 1:20 AMcompose-spicedb-1 | {"level":"debug","module":"pgx","args":["resource","alerts","reader","role","readonly","member","resource","views","reader","role","readonly","member"],"commandTag":"SU5TRVJUIDAgMg==","pid":86,"sql":"INSERT INTO relation_tuple (namespace,object_id,relation,userset_namespace,userset_object_id,userset_relation) VALUES ($1,$2,$3,$4,$5,$6),($7,$8,$9,$10,$11,$12)","time":2.139288,"time":"2022-10-14T00:56:57Z","message":"Exec"}
Jake
10/14/2022, 1:20 AMJake
10/14/2022, 1:21 AMcompose-spicedb-1 | {"level":"error","module":"pgx","args":["resource","alerts","reader","role","readonly","member","resource","views","reader","role","readonly","member"],"err":"ERROR: duplicate key value violates unique constraint \"uq_relation_tuple_living_xid\" (SQLSTATE 23505)","pid":86,"sql":"INSERT INTO relation_tuple (namespace,object_id,relation,userset_namespace,userset_object_id,userset_relation) VALUES ($1,$2,$3,$4,$5,$6),($7,$8,$9,$10,$11,$12)","time":0.718452,"time":"2022-10-14T00:56:57Z","message":"Exec"}