View My Definition

Question

Post reply

View My Definition

Andy Warren

SSC Guru

Points: 119902
More actions
March 6, 2014 at 10:50 pm

#146660

Comments posted to this topic are about the item View My Definition
Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
March 7, 2014 at 3:50 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 23 total)

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

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

Could have been this or could have been that but we assume the other.... didn't like the question, but thanks anyway.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

Good one, Andy. Thanks.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 3

Nice question, but I believe "not connected as sysadmin" is an equally correct answer though.

ps: no actual connections to a certain Grant who is always ranting? 😎

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

radek.hruby SSCrazy Points: 2123 More actions · Answer 4

I believe that the group name is not in the correct format i.e. [DOMAIN\GROUP] whether previously specified as a domain group ... and that would very probably cause the query to fail.

Carlo Romagnano SSC-Insane Points: 22596 More actions · Answer 5

Koen Verbeeck (3/7/2014)
Nice question, but I believe "not connected as sysadmin" is an equally correct answer though.
ps: no actual connections to a certain Grant who is always ranting? 😎

From BOL:

The grantor (or the principal specified with the AS option) must have either the permission itself with GRANT OPTION or a higher permission that implies the permission being granted. Members of the sysadmin fixed server role can grant any permission.

Carlo Romagnano SSC-Insane Points: 22596 More actions · Answer 6

Carlo Romagnano

SSC-Insane

Points: 22596

March 7, 2014 at 1:34 am

#1694995

free_mascot (3/6/2014)
Good one, Andy. Thanks.

+1

😉

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 7

Carlo Romagnano (3/7/2014)
Koen Verbeeck (3/7/2014)
Nice question, but I believe "not connected as sysadmin" is an equally correct answer though.
ps: no actual connections to a certain Grant who is always ranting? 😎
From BOL:
The grantor (or the principal specified with the AS option) must have either the permission itself with GRANT OPTION or a higher permission that implies the permission being granted. Members of the sysadmin fixed server role can grant any permission.

Nothing in the question implicates Grant has the permission itself (it's a very logical assumption that he has, but an assumption nonetheless).

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

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 8

Koen Verbeeck (3/7/2014)
Carlo Romagnano (3/7/2014)
Koen Verbeeck (3/7/2014)
Nice question, but I believe "not connected as sysadmin" is an equally correct answer though.
ps: no actual connections to a certain Grant who is always ranting? 😎
From BOL:
The grantor (or the principal specified with the AS option) must have either the permission itself with GRANT OPTION or a higher permission that implies the permission being granted. Members of the sysadmin fixed server role can grant any permission.
Nothing in the question implicates Grant has the permission itself (it's a very logical assumption that he has, but an assumption nonetheless).

QOD contains -- "Mr. Grant is managing a SQL 2012 instance."

is this not sufficient to know that Grant has sys admin rights ?

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 9

pmadhavapeddi22 (3/7/2014)
Koen Verbeeck (3/7/2014)
Carlo Romagnano (3/7/2014)
Koen Verbeeck (3/7/2014)
Nice question, but I believe "not connected as sysadmin" is an equally correct answer though.
ps: no actual connections to a certain Grant who is always ranting? 😎
From BOL:
The grantor (or the principal specified with the AS option) must have either the permission itself with GRANT OPTION or a higher permission that implies the permission being granted. Members of the sysadmin fixed server role can grant any permission.
Nothing in the question implicates Grant has the permission itself (it's a very logical assumption that he has, but an assumption nonetheless).
QOD contains -- "Mr. Grant is managing a SQL 2012 instance."
is this not sufficient to know that Grant has sys admin rights ?

Perhaps. Who knows?

Maybe the company has special admin logins with elevated privileges that admins can use if they need to make changes and Mr.Grant accidentally signed in using his regular account (with less privileges). It's all possible.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

Thanks Andy.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

trilist SSC Eights! Points: 902 More actions · Answer 11

If it was granting permission to an AD group where is the domain name? my answer was 'Wrong'

kafrazier SSC Enthusiast Points: 148 More actions · Answer 12

I thought too much about the question and figured they could have been denied control access at one point in time.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 13

Had to guess, and got it right. Thanks for the question, but questions that are this subjective are deprecated in future versions of SQL Server. 😉

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn