Re: Create table rights

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/29/05 

Date: Sun, 28 Aug 2005 19:13:26 -0600

Hi,

Looks like some one DENY the create table previlage for that user. But in
this case a GRANT command will over rule the DENY.
Could you post the exact error you are getting after running the GRANT
statement.

Thanks
Hari
SQL Server MVP

"jaylou" <jaylou@discussions.microsoft.com> wrote in message
news:8DF5770F-4D14-4ADE-A3F1-2A47AFB3AAD4@microsoft.com...
> hi All,
> I have given a user ddladmin to a database, but this user still can't
> create
> tables. I tried to "grant create tables to username" that ran sucessfully
> but still can't create a table in my DB.
>
> Can anyone tell me what I missed for this user? he can drop tables but
> not
> create them.
> Thanks,
> Joe
>