How to prevent a table from being truncated or dropped

Question

Post reply

How to prevent a table from being truncated or dropped

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

MMartin1 One Orange Chip Points: 27795 More actions · Answer 1

I guess things like this happen when there is no effort to learn what the other roles are, like ddl admin.

----------------------------------------------------

Eric M Russell SSC Guru Points: 125561 More actions · Answer 2

MMartin1 (8/26/2016)
I guess things like this happen when there is no effort to learn what the other roles are, like ddl admin.

But you probably know that db_ddbadmin will grant them permission to truncate or drop tables.

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

MMartin1 One Orange Chip Points: 27795 More actions · Answer 3

Eric M Russell (8/26/2016)
MMartin1 (8/26/2016)
I guess things like this happen when there is no effort to learn what the other roles are, like ddl admin.
But you probably know that db_ddbadmin will grant them permission to truncate or drop tables.

Oh yes. I was referring to your earlier post about giving a sysAdmin (more than needed) to some developers who would need to create tables. Just grant the db_ddlAdmin for the database where they need to work.

Granting developers and other users membership in the SYSADMIN ...

----------------------------------------------------