x

Permission

SQL 2008 R2.

Is there a way to "deny drop objects" (tables/procs/views..) on a database where a user has read/write + Alter permissons without using triggers?

Basically I would like the users to go crazy without deleting objects, they can create/modify/truncate whatever they want, just not delete anything.

more ▼

asked Dec 10, 2013 at 04:01 PM in Default

avatar image

raadee
4.5k 12 18 22

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You can't. As soon as you GRANT CONTROL on a schema, or worse, make people the database owner, you've granted them that control. There isn't a way to parse it.

more ▼

answered Dec 11, 2013 at 11:02 AM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x775
x122

asked: Dec 10, 2013 at 04:01 PM

Seen: 498 times

Last Updated: Dec 11, 2013 at 11:02 AM

Copyright 2017 Redgate Software. Privacy Policy