<div>
Hi<br />
with this Query you can sure for your permissions <br />
thanks<br />

<pre><code id="code-370031">SELECT * FROM sysobjects a
LEFT JOIN syspermissions b
ON a.id=b.id
WHERE a.xtype='P'
AND b.id IS NULL 
</code></pre>
</div>


Hi
with this Query you can sure for your permissions
thanks


SELECT * FROM sysobjects a
LEFT JOIN syspermissions b
ON a.id=b.id
WHERE a.xtype='P'
AND b.id IS NULL 


<div>
the error means what it says: the user cannot create a table in the schema dbo.<br />
you would need to add the role db_owner to that user, granting that user full access to the database.
</div>


the error means what it says: the user cannot create a table in the schema dbo.
you would need to add the role db_owner to that user, granting that user full access to the database.

<div>
Worked like a charm...Thanks
</div>


<div>
<div class="content wysiwyg-content">
Have granted create table to a SQL Server userid, and when I check the userid in Management Studio the grant is in place, but when I attempt to create a table as this user I get:<br />
<br />
The specified schema name &quot;dbo&quot; either does not exist or you do not have permission to use it.<br />
<br />
What am I missing...<br />
<br />
Dav<br />

<pre><code id="code-370017">create table dbo.testerito
(testid int)
go
</code></pre>
</div>
</div>


Have granted create table to a SQL Server userid, and when I check the userid in Management Studio the grant is in place, but when I attempt to create a table as this user I get:

The specified schema name "dbo" either does not exist or you do not have permission to use it.

What am I missing...

Dav

Problems with Grant Create Table on a database

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.