Create SCHEMA error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Create SCHEMA error

Create SCHEMA error

Rate Topic

Display Mode

Topic Options

Author

Message

timmynew11

Posted Monday, January 31, 2011 2:24 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 01, 2011 8:37 AM
Points: 7, Visits: 29

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)

Post #1056464

« Prev Topic | Next Topic »

Permissions