Click here to monitor SSC
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
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: Moderators
Points: 7225 Visits: 2679
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
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1291 Visits: 1865
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
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1923 Visits: 1060
Another incorrect answer for me.

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

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

Group: General Forum Members
Points: 1682 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
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5775 Visits: 7130
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
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2863 Visits: 5331
Good Q, didn't think much of the format if I'm honest though.
Hany Helmy
Hany Helmy
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: 2514 Visits: 1108
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
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: 2514 Visits: 1108
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.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2192 Visits: 3415
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