No More Denial

Question

No More Denial

Steve Jones - SSC Editor

SSC Guru

Points: 736255
More actions
June 12, 2019 at 12:00 am

#3526329

Comments posted to this topic are about the item No More Denial

Viewing 7 posts - 1 through 6 (of 6 total)

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

Stewart "Arturius" Campbell SSC Guru Points: 72626 More actions · Answer 1

Nice question, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

Great question that makes sense once you understand how privileges work. Use REVOKE to increase permissions. 🙂

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

rVadim Hall of Fame Points: 3969 More actions · Answer 3

rVadim

Hall of Fame

Points: 3969

June 12, 2019 at 5:00 pm

#3652837

REOVE DENY 🙂

--Vadim R.

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 4

Strange to me, and I wish this was "REVOKE GRANT" or "REVOKE DENY", but it does make sense.

David Conn SSCertifiable Points: 6010 More actions · Answer 5

It doesn't really make sense. Revoke Deny as you suggested would be more intuitive.

I'm having a T-SQL Syntax Issue with the World at the moment. You have to wonder whether these rules were made by a Commitee or just the Developer doing the Implementation.

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 6

Committees in most cases, perhaps an individual in some, but likely some group.

I think T-SQL, probably SQL as well, are horribly broken in their models. The whole "Create" "ALTER issue is silly. We could easily have just ALTER TABLE that creates it if it doesn't exist, and use parameters (add_in_place, add_at_end, etc.) for decisions about how changes are implemented.