Create SCHEMA error

• timmynew11

  SSC-Addicted

  Points: 425

  More actions

  January 31, 2011 at 2:24 pm

  #244506

  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)