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 12»»

Access Granted or Not? Expand / Collapse
Author
Message
Posted Monday, June 2, 2014 11:04 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Tuesday, May 26, 2015 9:14 AM
Points: 6,859, Visits: 2,085
Comments posted to this topic are about the item Access Granted or Not?

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #1576817
Posted Monday, June 2, 2014 11:13 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:02 AM
Points: 3,842, Visits: 9,944
Thank you Andy for a good question.

Quite certain I checked the right answer but still came as wrong. Either a bug or lack of industrial strength tanker sized espresso in the morning
Post #1576818
Posted Tuesday, June 3, 2014 1:19 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 5:30 AM
Points: 3,541, Visits: 1,409
Eirikur Eiriksson (6/2/2014)
lack of industrial strength tanker sized espresso in the morning

+1
Missed the "(select 2)".
Post #1576852
Posted Tuesday, June 3, 2014 1:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, May 26, 2015 1:12 AM
Points: 2,819, Visits: 2,688
This feature will be removed in a future version of Microsoft SQL Server.

http://msdn.microsoft.com/en-us/library/ms174378%28v=sql.110%29.aspx
Post #1576855
Posted Tuesday, June 3, 2014 1:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 5:35 AM
Points: 312, Visits: 80
Cheers Andy - had to start off with all of them and eliminate one by one this time :)
Post #1576864
Posted Tuesday, June 3, 2014 3:04 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:58 AM
Points: 2,720, Visits: 2,131
robertjtjones (6/3/2014)
Cheers Andy - had to start off with all of them and eliminate one by one this time :)

+1


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1576887
Posted Tuesday, June 3, 2014 3:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, May 26, 2015 11:53 PM
Points: 1,025, Visits: 1,664
Being sysadmin, I have worked with my own windows login authentication permissions and tried giving authentication off/on to a particular database, and got the answers correctly.

good question andy..
Post #1576897
Posted Tuesday, June 3, 2014 7:14 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:32 PM
Points: 4,438, Visits: 5,852
Good question, thanks Andy

I have encountered something similar when a user's domain password had expired during the course of the morning...


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1576957
Posted Tuesday, June 3, 2014 7:24 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: Wednesday, May 20, 2015 7:18 AM
Points: 872, Visits: 356
Thanks Andy - well written QOTD with explanations.
Post #1576963
Posted Tuesday, June 3, 2014 10:48 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:55 PM
Points: 2,073, Visits: 2,218
and of course I read "This user is granted access to the database via a domain group" as the newbie had already checked the permissions of the group on the database.
Post #1577060
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse