Symptoms
After having successfully created SmartObjects through SQL, there were issues with CRUD operations that threw an anonymous logon error.
Diagnoses
Service account access was not granted to the database
Resolution
The user granted the service account access to the database and that fixed the issue with the CRUD operations.