Logging Event Permissions

Question

Logging Event Permissions

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
July 17, 2020 at 12:00 am

#3769167

Comments posted to this topic are about the item Logging Event Permissions

Viewing 4 posts - 1 through 3 (of 3 total)

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

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 1

Heh... this is why I hate tests. While I knew the correct answer you were expecting, it's not actually the correct answer. It can be done through a stored procedure that has the correct privs and the user only actually needs PUBLIC (connect) and the privs to use the proc.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SADSAC SSCrazy Points: 2402 More actions · Answer 2

Agree with Jeff. from BOL:

Requires membership in the sysadmin fixed server role or membership in the public fixed database role in the master database with EXECUTE permission granted.

This reply was modified 4 years, 4 months ago by SADSAC.

Stewart "Arturius" Campbell SSC Guru Points: 72625 More actions · Answer 3

Don't entirely agree, but i suppose the given correct answer is the closest to the actual fact...

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