Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

The Case Of the Downward Pointing Arrow Expand / Collapse
Author
Message
Posted Tuesday, July 1, 2014 9:18 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Friday, September 12, 2014 7:39 AM
Points: 6,784, Visits: 1,894
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
Post #1588269
Posted Wednesday, July 2, 2014 1:20 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 3:14 AM
Points: 805, Visits: 1,401
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 ?
Post #1588331
Posted Wednesday, July 2, 2014 1:39 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 4, 2014 9:03 AM
Points: 1,415, Visits: 796
Another incorrect answer for me.

I think Andy Warren is Moriarty in disguise - bring back Steve now!
Post #1588332
Posted Wednesday, July 2, 2014 2:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 14, 2014 1:43 AM
Points: 215, Visits: 79
Fun way to pose a question, and gets me learning a new fact every time
Post #1588342
Posted Wednesday, July 2, 2014 3:03 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 2:52 AM
Points: 950, Visits: 2,162
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.
Post #1588358
Posted Wednesday, July 2, 2014 4:21 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:19 AM
Points: 3,953, Visits: 5,181
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”
Post #1588378
Posted Wednesday, July 2, 2014 4:46 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:18 AM
Points: 1,969, Visits: 3,254
Good Q, didn't think much of the format if I'm honest though.
Post #1588388
Posted Wednesday, July 2, 2014 4:54 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:30 AM
Points: 1,249, Visits: 590
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.
Post #1588390
Posted Wednesday, July 2, 2014 5:39 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:30 AM
Points: 1,249, Visits: 590
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;

Post #1588400
Posted Wednesday, July 2, 2014 7:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 12, 2014 1:53 PM
Points: 1,324, Visits: 2,283
Ugh, only got half the answer. I didn't think denying connect would have the same effect but apparently it does.

Interesting question.
Post #1588438
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse