Create table rights

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,
JoeWith the specific 'create table' permission or the DDLAdmin role membership
that should permit the user to creatr the table.
How is the user atempting to create the table? Are they executing a DDL
script? If they are executing a script, make sure that the CREATE TABLE
script does not have the dbo context set in the table name. If it does, an
d
the user executing the scriipt is not a DBO, then they will be unable to
successfully create the table. If the script does have dbo. in the table
name, just remove the dbo. from the name and try executing it.
"jaylou" wrote:

> hi All,
> I have given a user ddladmin to a database, but this user still can't crea
te
> 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 no
t
> create them.
> Thanks,
> Joe
>|||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
>|||i think the user is be a member of a denied group
or he is denied as an individual
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"jaylou" wrote:

> hi All,
> I have given a user ddladmin to a database, but this user still can't crea
te
> 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 no
t
> create them.
> Thanks,
> Joe
>|||Hi Hari,
Here is the error I get when I try to create a table with this userID
"Server: Msg 262, Level 14, State 1, Line 1
CREATE TABLE permission denied in database 'SOXstuff'."
I don't need to add him to a server role as well as the DB_DDLADMIN?
Thanks again,
Joe
"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 Jose,
Is there a way to find out if he is being denied? I have granted him
DB_DDLADMIN rights to the database. that should over ride the deny correct?
Thanks,
Joe
"Jose G. de Jesus Jr MCP, MCDBA" wrote:
[vbcol=seagreen]
> i think the user is be a member of a denied group
> or he is denied as an individual
>
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787
>
> "jaylou" wrote:
>|||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 Hari
Which case are you talking about that GRANT will overrule a DENY?
Thanks
Kalen Delaney
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:Od%237RfPrFHA.528@.TK2MSFTNGP09.phx.gbl...
> 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...
>
>|||Kalen,
From my understanding Grant will override the exsisting deny as well as a
deny staement will override the exsisting Grant. I may be wrong since I can
t
seem to get my user create table rights in my DB without giving DB_Owner
rights.
"Kalen Delaney" wrote:

> Hi Hari
> Which case are you talking about that GRANT will overrule a DENY?
> Thanks
> Kalen Delaney
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:Od%237RfPrFHA.528@.TK2MSFTNGP09.phx.gbl...
>
>|||Don't think a grant overrides a deny. Deny takes precedence.
It almost sounds like you may be referring to revoke which
removes a previously granted or denied permission. Revoke
and Deny are very different.
-Sue
On Tue, 30 Aug 2005 13:19:07 -0700, jaylou
<jaylou@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Kalen,
>From my understanding Grant will override the exsisting deny as well as a
>deny staement will override the exsisting Grant. I may be wrong since I ca
nt
>seem to get my user create table rights in my DB without giving DB_Owner
>rights.
>"Kalen Delaney" wrote:
>