SQL Server Agent Proxies

Question

Post reply

SQL Server Agent Proxies

Steve Jones - SSC Editor

SSC Guru

Points: 734418
More actions
May 14, 2012 at 10:10 pm

#74732

Comments posted to this topic are about the item SQL Server Agent Proxies
May 15, 2012 at 2:26 am

This was removed by the editor as SPAM

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

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

M&M SSC-Insane Points: 21700 More actions · Answer 1

M&M

SSC-Insane

Points: 21700

May 14, 2012 at 10:18 pm

#1487518

Good question. 🙂

M&M

baabhu SSCertifiable Points: 6205 More actions · Answer 2

baabhu

SSCertifiable

Points: 6205

May 15, 2012 at 1:17 am

#1487550

Nice 🙂

forsqlserver SSCoach Points: 18902 More actions · Answer 3

forsqlserver

SSCoach

Points: 18902

May 15, 2012 at 2:43 am

#1487575

very nice

Thanks

HanShi SSC-Dedicated Points: 33506 More actions · Answer 4

Stewart "Arturius" Campbell (5/15/2012)
Nice, simple question, thanks Steve
what is disturbing is how many (45% at this point in time) of responders selected "yes".

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.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 5

nice question!!!

thanks Steve!!!!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Toreador SSChampion Points: 11358 More actions · Answer 6

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.

That's right, I guessed wrong (50% chance) 🙂 I thought it might show the node but give an error if you tried to access it.

Mike Is Here Hall of Fame Points: 3348 More actions · Answer 7

I just went through this for a user, nice timely question.

chrisfradenburg SSCrazy Eights Points: 9592 More actions · Answer 8

HanShi (5/15/2012)
I answered this from the top of my head and thought the folder would be visible but not able to expand and/or view.

I was wondering if that was the case but went with the cleaner, "If it can't be used, it shouldn't be shown," thought and was right. I'm betting if there was a third option of it showing but not being usable that's where most of the yeses would have been.

TomThomson SSC Guru Points: 104773 More actions · Answer 9

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 SSChampion Points: 10761 More actions · Answer 10

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.)

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

Toreador SSChampion Points: 11358 More actions · Answer 11

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 SSCertifiable Points: 5394 More actions · Answer 12

Anyone remembers SQL2000 Enterprise Manager? It is visible there (with Jobs only). I had that in mind and missed :blush:

dpathak02 SSC Veteran Points: 280 More actions · Answer 13

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 🙁