Allow user to GRANT certain permissions to others
you can use GRANT ... WITH GRANT OPTION.
https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-transact-sql?view=sql-server-ver15
this option specifies that the security principal receiving the permission is given the ability to grant the specified permission to other security accounts.