DBCC InputBuffer Permissions

Question

DBCC InputBuffer Permissions

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
May 28, 2015 at 8:37 pm

#304293

Comments posted to this topic are about the item DBCC InputBuffer Permissions
May 29, 2015 at 2:31 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

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

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 1

Thanks for this easy question. But it remembers me an interview in 2010 where I have not been able to give the good solution ( the sysadmin permission was too much trivial to be accepted by the interviewer ). But the interviewer was clever and used the computer on his table to show me the results : a simple way which avoids many discussions and pleasant as it is easier for me to remember something I have seen/read than listened. But an habit too much forgotten or ignored by interviewers ...

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

A nice question to end the week. Thanks, Steve.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

webrunner SSC-Dedicated Points: 31863 More actions · Answer 4

Thanks, nice question.

There is no such thing as "Impersonate Sysadmin," is there??

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

TomThomson SSC Guru Points: 104773 More actions · Answer 5

Nice question.

But one doesn't need the specified permission to use DBCC INPUTBUFFER to look at the session one is running in. This has been true in every release since SQL 2000 (I don't know whether it was true for earlier versions). Of course that is a pretty restricted use of DBCC INPUTBUFFER, and more general use needs the VIEW SERVER STATE permission.

Tom

Revenant SSC-Forever Points: 42467 More actions · Answer 6

Revenant

SSC-Forever

Points: 42467

May 29, 2015 at 9:55 am

#1801638

Neat. Thanks, Steve!

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 7

SQL_Hunt

SSC-Dedicated

Points: 33518

May 29, 2015 at 8:02 pm

#1801786

Got full credit...

Thanks.

Hany Helmy SSChampion Points: 13921 More actions · Answer 8

Guessed it right, thanx 4 the question.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 9

akljfhnlaflkj

SSC Guru

Points: 76202

June 2, 2015 at 7:18 am

#1802273

Thanks for the question.

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

It's good to remind folks that privillages, even for more advanced things like operating backups or running performance tuning queries, can be granted piecemeal without adding the login to SYSADMIN membership.

It would be useful if SSMS under ..\Security\Logins would highlight those logins with sysadmin membership, and also be smart enough to identify those logins who inherit sysadmin membership by virtue of their domain group rather than just those logins explicitly granted membership by DBA.

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

stephen.long.1 SSCrazy Points: 2582 More actions · Answer 11

I was also able to guess the correct answer (I'm not a DBA). Thanks for the question, Steve.