Symptoms
The client wants to know if a TestUser would need DB owner-rights in order register a service instance and have full properties as the DB owner.
For example At this point when registering the SQL service in instance as a testUser the property that is an Autoguid is showing as a normal guid that needs a user to input the guid themselves, its not auto-generated. However when registering the SQL service instance as a DB owner it shows the property as AutoGuid or as an autogenerated value.
Diagnoses
After investigating the issue and reproduced this behavouir, we came up with the workaround below: by granting permission on view Definition on the table level,
Resolution
By granting permission on View Definition on the table level on the Database