|
Home > Archive > MS SQL Server > August 2005 > how to permit only drop user tables
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
how to permit only drop user tables
|
|
| Mariano 2005-08-30, 8:23 pm |
| 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 only
drop the tables that he create. What i can do??
| |
| Alejandro Mesa 2005-08-30, 8:23 pm |
| 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 only
> drop the tables that he create. What i can do??
| |
| Mariano 2005-08-30, 8:23 pm |
| 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:
[color=darkred]
> 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:
>
|
|
|
|
|