The following script errors out when creating a new user. The new user gets created, just the schema does not. What permissions am I missing.
SET @SQL = 'CREATE SCHEMA [' + @username + '] AUTHORIZATION [' + @username + ']';
EXECUTE(@SQL);
the username is being passed from another program via ODBC to create the User. Other than making the ODBC user credentials sysadmin, what do I need to grant?
ERROR:
Cannot find the user 'TEST', because it does not exist or you do not have permission (#15151). CREATE SCHEMA failed due to previous errors (#2159)