GrantRoleToSubject

2026-08-10T15:06:36.112Z  WARN 380 --- [o-auto-3-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: P0001
2026-08-10T15:06:36.112Z ERROR 380 --- [o-auto-3-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: [403] Access to granted role rbactest.package#yyy00:ADMIN (cb37980e-86d4-49c4-bccc-c5d25e9992b6) forbidden for rbactest.package#xxx00:ADMIN (55992e96-37ca-4c96-b475-dbcb60574c79)
  Where: PL/pgSQL function rbac.grantroletosubject(uuid,uuid,uuid,boolean) line 22 at RAISE
SQL statement "call rbac.grantRoleToSubject(rbac.assumedRoleUuid(), new.grantedRoleUuid, new.subjectUuid, new.assumed)"
PL/pgSQL function rbac.insert_grant_tf() line 5 at CALL
HTTP/1.1 403 
Vary: Origin
Vary: Access-Control-Request-Method
Vary: Access-Control-Request-Headers
X-Content-Type-Options: nosniff
X-XSS-Protection: 0
Cache-Control: no-cache, no-store, max-age=0, must-revalidate
Pragma: no-cache
Expires: 0
X-Frame-Options: DENY
Content-Type: application/json
Transfer-Encoding: chunked
Date: Mon, 10 Aug 2026 15:06:36 GMT
Keep-Alive: timeout=60
Connection: keep-alive

{
    "timestamp": "2026-08-10 03:06:36",
    "path": "",
    "statusCode": 403,
    "statusPhrase": "Forbidden",
    "message": "ERROR: [403] Access to granted role rbactest.package#yyy00:ADMIN (cb37980e-86d4-49c4-bccc-c5d25e9992b6) forbidden for rbactest.package#xxx00:ADMIN (55992e96-37ca-4c96-b475-dbcb60574c79)"
}
HTTP/1.1 201 
Vary: Origin
Vary: Access-Control-Request-Method
Vary: Access-Control-Request-Headers
Location: http://localhost:46703/api/rbac.yaml/grants/55992e96-37ca-4c96-b475-dbcb60574c79
X-Content-Type-Options: nosniff
X-XSS-Protection: 0
Cache-Control: no-cache, no-store, max-age=0, must-revalidate
Pragma: no-cache
Expires: 0
X-Frame-Options: DENY
Content-Type: application/json
Transfer-Encoding: chunked
Date: Mon, 10 Aug 2026 15:06:36 GMT
Keep-Alive: timeout=60
Connection: keep-alive

{
    "grantedByRoleIdName": "rbactest.package#xxx00:ADMIN",
    "grantedByRole.uuid": "55992e96-37ca-4c96-b475-dbcb60574c79",
    "assumed": true,
    "grantedRoleIdName": "rbactest.package#xxx00:ADMIN",
    "grantedRole.uuid": "55992e96-37ca-4c96-b475-dbcb60574c79",
    "granteeSubjectName": "tst-user_zebzwdhl",
    "granteeSubject.uuid": "848ca3e6-abed-4e12-b67b-70cde7fb5a8a"
}