Re: Create table rights

From: jaylou (jaylou_at_discussions.microsoft.com)
Date: 08/30/05 

Date: Tue, 30 Aug 2005 06:13:03 -0700

If I try to create in EM. I get a message saying:
I am not logged on as databse owner or SA.
When I try to save it it tells me I dnt have create rights.

Do I need to be SA or owner to create a table? I didnt think I had to be.

"Hari Prasad" wrote:

> 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
> >
>
>
>