Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

View My Definition Expand / Collapse
Author
Message
Posted Thursday, March 6, 2014 10:50 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Thursday, July 2, 2015 10:15 PM
Points: 6,899, Visits: 2,152
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
Post #1548574
Posted Thursday, March 6, 2014 10:51 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, June 26, 2015 12:58 AM
Points: 1,814, Visits: 806
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





Post #1548575
Posted Thursday, March 6, 2014 11:41 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, July 3, 2015 12:49 AM
Points: 2,793, Visits: 2,162
Good one, Andy. Thanks.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1548581
Posted Friday, March 7, 2014 12:37 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:42 AM
Points: 14,471, Visits: 12,459
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?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1548593
Posted Friday, March 7, 2014 1:01 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 26, 2015 12:51 AM
Points: 935, Visits: 152
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.
Post #1548600
Posted Friday, March 7, 2014 1:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:51 AM
Points: 2,864, Visits: 2,735
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.
Post #1548601
Posted Friday, March 7, 2014 1:34 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:51 AM
Points: 2,864, Visits: 2,735
free_mascot (3/6/2014)
Good one, Andy. Thanks.

+1
Post #1548602
Posted Friday, March 7, 2014 1:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:42 AM
Points: 14,471, Visits: 12,459
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).




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1548609
Posted Friday, March 7, 2014 3:50 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, July 3, 2015 11:40 AM
Points: 4,505, Visits: 5,962
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).


+1


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1548651
Posted Friday, March 7, 2014 5:15 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 1, 2015 3:36 AM
Points: 1,045, Visits: 1,685
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 ?
Post #1548682
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse