<div>
Try..<br />
<br />
USE YourDBName; &nbsp;<br />
GRANT CREATE TABLE TO Pawan; &nbsp;<br />
GO <br />
<br />
USE YourDBName; &nbsp;<br />
GRANT ALTER TABLE TO Pawan; &nbsp;<br />
GO <br />
<br />
<br />
Note - Pawan is your user name
</div>


Try..

USE YourDBName;  
GRANT CREATE TABLE TO Pawan;  
GO

USE YourDBName;  
GRANT ALTER TABLE TO Pawan;  
GO


Note - Pawan is your user name

<div>
Hi, <br />
<br />
Many thanks for the response. I have given the role create table permissions, but they are still unable to create a table. I am unable to apply the alter script. <br />
<br />
Thanks
</div>


Hi,

Many thanks for the response. I have given the role create table permissions, but they are still unable to create a table. I am unable to apply the alter script.

Thanks

<div>
This means you do not have access to perform &nbsp;these operations.<br />
<br />
Are you the admin on the SQL Server. Also ask the person to disconnect SSMS and connect again.
</div>


This means you do not have access to perform  these operations.

Are you the admin on the SQL Server. Also ask the person to disconnect SSMS and connect again.

<div>
Hi,<br />
I am sa on the server. I have asked the user to disconnect and reconnect but the error persists.<br />
<br />
Thanks
</div>


Hi,
I am sa on the server. I have asked the user to disconnect and reconnect but the error persists.

Thanks

<div>
Can you please provide me the screen shot the current access setting he has ?
</div>


Can you please provide me the screen shot the current access setting he has ?

<div>
Hi,<br />
<br />
One thing I have realises is that role that requires access does not have a schema associated with it. Should it have one?<br />
<br />
Thanks
</div>


Hi,

One thing I have realises is that role that requires access does not have a schema associated with it. Should it have one?

Thanks

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
How would I grant create and alter table to a role in SQL Server 2005? &nbsp;The development team wish to use the Entity Framework in their application and this requires that role has the create and alter table permissions. Any guidance would be appreciated.<br />
<br />
Thanks
</div>
</div>


Hi,

How would I grant create and alter table to a role in SQL Server 2005?  The development team wish to use the Entity Framework in their application and this requires that role has the create and alter table permissions. Any guidance would be appreciated.

Thanks

Table create permissions on SQL Server 2005

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.