[Bug]: Assign instance admin role for the first user in the instance

[abhvsn]

Is there an existing issue for this?

• I have searched the existing issues

Description

In the normal flow when user starts the new instance and lands on homepage {base_url} she gets redirected to {base_url}/setup/welcome where we ask user to fillup the super user form and server treats this as a super user. But if user ends up on {base_url}/user/signup server does not check if this is the first non-system-generated user and ends up treating a normal user. This leads to the instance without any instance admin.

Steps To Reproduce

1. Start the container
2. Signup to the instance
3. User will have the admin access
4. Change the DB url from the admin setting or via env
5. User will be logged out, try to sign in again
6. User doesn't get the instance admin access

Public Sample App

No response

Environment

Production

Severity

Medium (Frustrating UX)

Issue video log

No response

Version

v1.43