Files
grafana/pkg/registry/apis/iam/legacy/create_org_user.sql
MisiandGabriel Mabille c6a6b9fdd2 IAM: Create and delete user from the legacy store (#107694)
* Add Create for User + DualWriter setup

* Add delete User

* Fix delete + access check

* Add tests for delete user

* Add tests for create user

* Fixes

* Use sqlx session to fix database locked issues

* wip authz checks

* legacyAccessClient

* Update legacyAccessClient, add tests for create user

* Close rows before running other queries

* Use ExecWithReturningId

* Verify deletion in the tests

* Add Validate and Mutate

* Other changes

* Address feedback

* Update tests

---------

Co-authored-by: Gabriel Mabille <gabriel.mabille@grafana.com>
2025-07-17 11:50:40 +02:00

6 lines
238 B
SQL

INSERT INTO {{ .Ident .OrgUserTable }}
(org_id, user_id, role, created, updated)
VALUES
({{ .Arg .Command.OrgID }}, {{ .Arg .Command.UserID }}, {{ .Arg .Command.Role }},
{{ .Arg .Command.Created }}, {{ .Arg .Command.Updated }})