July 1, 2014 at 9:18 pm
Comments posted to this topic are about the item The Case Of the Downward Pointing Arrow
July 2, 2014 at 1:20 am
to arrive to the solution, I tried with guest account (because this account generally has downward pointing arrow)
so , one option is for sure,
Connect permission has been revoked
after this When I tried to disable the login
ALTER LOGIN test_login disable;
The above statement turned the user with downward pointing arrow in red
So I have selected the option
The associated login has been disabled
Where I went wrong ? or the given answers are correct ?
July 2, 2014 at 1:39 am
Another incorrect answer for me.
I think Andy Warren is Moriarty in disguise - bring back Steve now!
July 2, 2014 at 2:21 am
Fun way to pose a question, and gets me learning a new fact every time 😉
July 2, 2014 at 3:03 am
Thank you Andy for the post, very nicely put, but for me it was like "wow I don't know anything about sql".
I can't figure it out how to revoke and deny the connect permission to the login?
All I know the basic step, go to that login, properties, status, there you can select "deny" for the permission to connect... - So if I consider this as "Connect permission has been denied" then what is actually a "Connect permission has been revoked"? and how to do that?
I have witnessed this - After selecting "deny" of that login in the status tab "and" disabling the login, then only I was able to see the red arrow for that user under the Server\Security\Login... but that User in the specific database (Server\Database\Security\User) there was no changes in the icon.
From the Transcript - Van Dyke's second response as he mentions "...some of the user accounts" - I understand that we are suppose to look under this "Server\Database\Security\User" and not "Server\Security\Login"?
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
July 2, 2014 at 4:21 am
This was removed by the editor as SPAM
July 2, 2014 at 4:47 am
Good Q, didn't think much of the format if I'm honest though.
July 2, 2014 at 4:54 am
pmadhavapeddi22 (7/2/2014)
to arrive to the solution, I tried with guest account (because this account generally has downward pointing arrow)so , one option is for sure,
Connect permission has been revoked
after this When I tried to disable the login
ALTER LOGIN test_login disable;
The above statement turned the user with downward pointing arrow in red
So I have selected the option
The associated login has been disabled
Where I went wrong ? or the given answers are correct ?
That`s on the Server Security level, but the question pointed to [the user accounts in my databases], this is in the database security level.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
July 2, 2014 at 5:39 am
Raghavendra Mudugal (7/2/2014)
Thank you Andy for the post, very nicely put, but for me it was like "wow I don't know anything about sql".I can't figure it out how to revoke and deny the connect permission to the login?
All I know the basic step, go to that login, properties, status, there you can select "deny" for the permission to connect... - So if I consider this as "Connect permission has been denied" then what is actually a "Connect permission has been revoked"? and how to do that?
To revoke a connect permission from user, this is to be done from the database security level like follows:
Revoke Connect from User_Name; or to deny the user from connectong to the database:
Deny Connect to User_Name;
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
July 2, 2014 at 7:23 am
Ugh, only got half the answer. I didn't think denying connect would have the same effect but apparently it does. :pinch: 😀
Interesting question. 🙂
July 2, 2014 at 8:27 am
Hany Helmy (7/2/2014)
To revoke a connect permission from user, this is to be done from the database security level like follows:
Revoke Connect from User_Name;or to deny the user from connectong to the database:
Deny Connect to User_Name;
Thank you, Hany, that helped.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
July 2, 2014 at 8:31 am
Thanks for the question, Andy. I liked the Holmes theme. I only wish I had gotten the answer correct.:(
You forgot to give the answer to "how did Holmes deduce that our client was a local SQL group leader?". I assume it has something to do with the fact that Van Dyke refers to "some of the user accounts" as opposed to "my user account". Is there more to it than that?
July 2, 2014 at 8:37 am
pretty sure you get the red arrow if you disable a login or did I misread something here.
July 2, 2014 at 8:50 am
Stephen, I'll delay the answer on that a bit longer. It's a stretch to figure it out, requires some knowledge not in the question (which is why it was an extra).
July 2, 2014 at 10:31 am
I met Kendal once in a SQL Saturday at Orlando but couldn't relate him. the description doesn't fit him at all. 😛
Viewing 15 posts - 1 through 15 (of 27 total)
You must be logged in to reply to this topic. Login to reply