Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Agent Proxies


SQL Server Agent Proxies

Author
Message
TomThomson
TomThomson
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10767 Visits: 12019
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

Thomas Abraham
Thomas Abraham
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2353 Visits: 2254
HanShi (5/15/2012)
Unfortunate I was one of the 45% answering wrong Sad. 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
Toreador
Toreador
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2421 Visits: 8064
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.
dawryn
dawryn
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3288 Visits: 894
Anyone remembers SQL2000 Enterprise Manager? It is visible there (with Jobs only). I had that in mind and missed Blush
dpathak02
dpathak02
SSC Veteran
SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)

Group: General Forum Members
Points: 280 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 Sad
Toreador
Toreador
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2421 Visits: 8064
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 Sad


If he can see the folder then my answer is correct and I want my point back!
SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21115 Visits: 18259
thanks for the question.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw

CoolCodeShare
CoolCodeShare
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1226 Visits: 311
Nice question!
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16518 Visits: 13210
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 SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Hardy21
Hardy21
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1204 Visits: 1399
Good one...

Thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search