Dropping the Aggregate

Question

Post reply

Dropping the Aggregate

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
November 8, 2021 at 12:00 am

#3946799

Comments posted to this topic are about the item Dropping the Aggregate

Viewing 9 posts - 1 through 8 (of 8 total)

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

edwardwill SSCertifiable Points: 5851 More actions · Answer 1

I don't understand the answer. The linked article states:

Permissions

To execute DROP AGGREGATE, at a minimum, a user must have ALTER permission on the schema to which the user-defined aggregate belongs, or CONTROL permission on the aggregate.

So the user only needs one permission - either ALTER on the schema or CONTROL on the aggregate.

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 2

It is either of those. I wasn't quite sure how to word the question. I'm still not sure.

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 3

It is either of those. I wasn't quite sure how to word the question. I'm still not sure.

frederico_fonseca SSCoach Points: 16154 More actions · Answer 4

MS documentation can be tricky - as Control is a superset of permissions that contain ALTER it means that CONTROL should never have been worded as being a minimum permission for ANYTHING where one of the underlying permissions is what really grants the permission.

George Vobr SSCrazy Eights Points: 9996 More actions · Answer 5

Hi Steve, and what about this: "Which database permission levels below can I use to run DROP AGGREGATE in SQL Server 2019?"

This reply was modified 3 years ago by George Vobr.

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

Maybe, George. Still might imply multiple things. Maybe "Of these permissions, which two represent either of a minimum permission needed?"

This one is tricky.

George Vobr SSCrazy Eights Points: 9996 More actions · Answer 7

You'll probably make fun of me for not ending it yet but I had some time, so maybe:

"Which permission, at a minimum, should a user have to execute DROP AGGREGATE? Select two of the options below that can be used. It is understood that you grant only one of them."

So, that's it, and I promise I'll give peace... 🙂

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 8

Steve Jones - SSC Editor

SSC Guru

Points: 736172

November 9, 2021 at 5:18 pm

#3949562

I like it. Better than my idea.

Question updated.