Posted by Erland Sommarskog on 09/20/07 21:27

Sharif Islam (mislam@npspam.uiuc.edu) writes:
> I gave a user explicit permission to create table, but still getting
> this error:
>
> Property Default Schema is not available for database[DBNAME]. This
> property may not exist for this object or may not be recoverable due to
> insufficient access right. Microsoft.SQLServer.Express.SQLEditors

Sounds like you are using some graphical tool in SSMS. Those tools are
of poor quality, and I recommend that you try CREATE TABLE instead.

But only CREATE TABLE may not be sufficient. The user may also need ALTER
permission on the schema (for instance dbo).


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]