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

SQL Server Agent Proxies Expand / Collapse
Author
Message
Posted Tuesday, May 15, 2012 7:47 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:33 PM
Points: 8,571, Visits: 9,076
Toreador (5/15/2012)
Stewart "Arturius" Campbell (5/15/2012)
what is disturbing is how many (45% at this point in time) of responders selected "yes".


Why is that disturbing? It's not as if it's important to know it.

In practise I've never had any use for guest; never allowed anyone to put anything into a guest schema; never allowed guests to do anything; so of course I didn't know the answer (and suspect that I'm not in a minority in that approach to the guest user); but got it right by common sense reasoning, not by random guessing.
Maybe what's disturbing is that so many people guessed wrong, on something which seems to be very easy to get right by thinking about it a bit, even if one doesn't actually know the answer?
My reasoning is that (apart from owning the guest schema) guest by default has no permissions other than connect (and that is something which everyone must surely know?) so he can't see anything other than the guest schema (and presumably its contents, if any). However, there may be something illogical about that reasoning, perhaps it's just a lucky (for my point score) accident that it leads to the correct answer correct answer; and it could be that "Arturius"' reason for finding it disturbing is something altogether different.


Tom
Post #1300232
Posted Tuesday, May 15, 2012 7:58 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:37 AM
Points: 1,769, Visits: 2,143
HanShi (5/15/2012)
Unfortunate I was one of the 45% answering wrong . I answered this from the top of my head and thought the folder would be visible but not able to expand and/or view.


My first thought was that it shouldn't be visible. But, as other's like HanShi above, I was afraid that it would be visible but disabled. So, I tested it.

As Sigourney Weaver said, "Nuke it from orbit. It's the only way to be sure."

(Edited to correct quote attribution.)


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1300244
Posted Tuesday, May 15, 2012 7:59 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:28 AM
Points: 1,714, Visits: 6,256
L' Eomot Inversé (5/15/2012)
got it right by common sense reasoning, not by random guessing.


My common sense reasoning (followed by a random guess) was that there are plenty of other places that MS will show you something and only tell you that you don't have access when you try to select it. A folder in Windows Explorer for instance.
Post #1300246
Posted Tuesday, May 15, 2012 8:11 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 10, 2014 1:48 AM
Points: 2,359, Visits: 730
Anyone remembers SQL2000 Enterprise Manager? It is visible there (with Jobs only). I had that in mind and missed
Post #1300263
Posted Tuesday, May 15, 2012 9:15 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, September 19, 2012 10:06 AM
Points: 278, Visits: 27
Well, there is a difference in "see" and "view"! Joe can see the Agent folder but he can not view/access the folder. Based on this interpretation, I got it wrong
Post #1300346
Posted Tuesday, May 15, 2012 9:19 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:28 AM
Points: 1,714, Visits: 6,256
dpathak02 (5/15/2012)
Well, there is a difference in "see" and "view"! Joe can see the Agent folder but he can not view/access the folder. Based on this interpretation, I got it wrong


If he can see the folder then my answer is correct and I want my point back!
Post #1300351
Posted Tuesday, May 15, 2012 7:58 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 4:30 PM
Points: 21,290, Visits: 14,982
thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1300722
Posted Tuesday, May 15, 2012 10:05 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 7:06 AM
Points: 1,216, Visits: 308
Nice question!
Post #1300754
Posted Wednesday, May 16, 2012 1:30 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:02 PM
Points: 13,334, Visits: 10,201
Great question, thanks.



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 #1300811
Posted Wednesday, May 16, 2012 1:51 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 6:54 AM
Points: 1,032, Visits: 1,295
Good one...

Thanks
Post #1300829
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse