September 28, 2007 at 2:20 am
hi friends..
i want to prevent a user login to enterprise manager but to allow that user to use in connetion string for connecting to database through the program (c#).
what do i do to achieve this in sql server...
stephen
September 28, 2007 at 2:25 am
steevlee (9/28/2007)
hi friends..i want to prevent a user login to enterprise manager but to allow that user to use in connetion string for connecting to database through the program (c#).
what do i do to achieve this in sql server...
stephen
I do not think you can do this. But what are you trying to achieve? Are you sure you cannot achieve the same by setting permissions properly for the databases/database objects?
Regards,
Andras
September 28, 2007 at 9:15 am
Well seeing as this is a SQL 2005 forum sure you could.... Login triggers, detect which application and user is loging in, then roll back the login attempt when you find that user loging in with EM....
Now since you said Enterprise Manger, this most likely should have been posted in the SQL 2000 forums. In which case that would not work
September 28, 2007 at 2:48 pm
hi Anders Pedersen
could you please explain more "Login Triggers" ..? :w00t:
i know how to write triggers..
but "Login Triggers" where do i start..
regards
stephen
September 30, 2007 at 12:39 am
You can find more information on what Logon triggers are and how to use them (along with an example) at: http://www.sqlcommunity.com/SQLTips/tabid/77/grm2id/40/Default.aspx
Thank you,
Saleem
October 1, 2007 at 12:24 am
steevlee (9/28/2007)
...could you please explain more "Login Triggers" ..? :w00t:
Keep in mind logon triggers have only been implemented with SQL2005 as from SP2 and off course they are at instance level ! 😎
Keep in mind to update your SQL2005 BOL for the latest info (may2007 is active)
check "CREATE TRIGGER" in BOL
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 1, 2007 at 4:04 am
If the application doesn't use the system tables then application roles?
http://www.microsoft.com/technet/technetmag/issues/2006/01/ProtectMetaData/
October 1, 2007 at 9:42 pm
Lowell had an interesting thought in another thread. Use Windows security to prevent him/her from running the EM executable. That might work.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply