SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The Case Of the Downward Pointing Arrow


The Case Of the Downward Pointing Arrow

Author
Message
Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11389 Visits: 2730
Comments posted to this topic are about the item The Case Of the Downward Pointing Arrow

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
pmadhavapeddi22
pmadhavapeddi22
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1508 Visits: 1870
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 ?
paul s-306273
paul s-306273
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: 2377 Visits: 1105
Another incorrect answer for me.

I think Andy Warren is Moriarty in disguise - bring back Steve now!
sqlsniper
sqlsniper
SSC-Addicted
SSC-Addicted (479 reputation)SSC-Addicted (479 reputation)SSC-Addicted (479 reputation)SSC-Addicted (479 reputation)SSC-Addicted (479 reputation)SSC-Addicted (479 reputation)SSC-Addicted (479 reputation)SSC-Addicted (479 reputation)

Group: General Forum Members
Points: 479 Visits: 160
Fun way to pose a question, and gets me learning a new fact every time ;-)
Raghavendra Mudugal
Raghavendra Mudugal
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2070 Visits: 2958
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.
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8771 Visits: 7279
This was tricky. I almost actioned as if on the SQL server security level, but re-read, to discover it refers to the database security level.
Very interesting question, thanks Andy...

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Gazareth
Gazareth
Hall of Fame
Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)

Group: General Forum Members
Points: 3977 Visits: 5798
Good Q, didn't think much of the format if I'm honest though.
Hany Helmy
Hany Helmy
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3013 Visits: 1117
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.
Hany Helmy
Hany Helmy
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3013 Visits: 1117
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;


sestell1
sestell1
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2530 Visits: 3458
Ugh, only got half the answer. I didn't think denying connect would have the same effect but apparently it does. Pinch :-D

Interesting question. :-)
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