how to permit only drop user tables

Hi, i want to permit a user to create tables and only drop the tables that h
e
creates. With db_ddladmin he can drop any table, but i want than he can only
drop the tables that he create. What i can do??

Mariano,

Do not add this user to roles sysadmin, db_owner or db_ddladmin. Instead,
allow him to create tables using "grant". In this way, he can create tables
and drop his tables but he can not drop tables owned by other users.


AMB

"Mariano" wrote:

> Hi, i want to permit a user to create tables and only drop the tables that
 he
> creates. With db_ddladmin he can drop any table, but i want than he can on
ly
> drop the tables that he create. What i can do??

Ok, thx for your answer, but how i allow him to create tables using "grant"?
?
What i have to do? Onetime i allow him to exec dt_adduserobject,
 dt_adduserobject_vcs
,  dt_droppropertiesbyi
d,  dt_dropuserobjectbyi
d and it
works, but now i do the same and itsn´t work. Can you help me?

"Alejandro Mesa" wrote:

> Mariano,
>
> Do not add this user to roles sysadmin, db_owner or db_ddladmin. Instead,
> allow him to create tables using "grant". In this way, he can create table
s
> and drop his tables but he can not drop tables owned by other users.
>
>
> AMB
>
> "Mariano" wrote:
>