SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
How to retrieve the users as well when filtering for logins?

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
How to retrieve the users as well when filtering for logins?
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2109

Post How to retrieve the users as well when filtering for logins? Reply with quote
Any way to add the users to login filter like you added the triggers to procedure filter in $OBJECT(...)$ here?
Fri Jun 22, 2012 4:51 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Users should be seen in the schema list. I'm afraid this list cannot be merged with the logins list.
You can modify "Schemas (MSSQL)" query and add users to the last UNION SELECT as if they were login names, not user names with SL type, but I'm really unsure of the overall impact of that change as it may have implications beyond the popup list
Fri Jun 22, 2012 10:23 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2109

Post Reply with quote
I'll leave it alone then, at least until I can find some time to play with it and repair the damage done. My experience is that tinkering with those queries is quite dangerous and resulted in disaster several times in the past :) Thanks for the feedback.
Fri Jun 22, 2012 10:29 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.