SQLServerCentral.com / SQL Server 2008 - General / SQL Server 2008 / IP Restriction Feature / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 20:14:44 GMT20RE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspxSure Gail, Incase of any query i will reply here.. thanks for Update :-)Tue, 27 Aug 2013 06:57:40 GMTOnlyOneRJRE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspxTry Books Online (the SQL help file). It has pages and pages on both.Tue, 27 Aug 2013 06:43:55 GMTGilaMonsterRE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspxGail, actually i have never worked on Triggers & audits & so looking out details in google..But didnt get any good documents for this... so me scared to implementTue, 27 Aug 2013 06:42:42 GMTOnlyOneRJRE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspxOnce more with feeling.Triggers.Audits.The functionality exists, and I've mentioned this repeatedly over a few weeks now, so I don't know why you're still puzzled.Tue, 27 Aug 2013 06:27:27 GMTGilaMonsterRE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspx[quote][b]Lowell (8/27/2013)[/b][hr]I suspect the core issue is that everyone logged in has sysadmin or dbo priviledges and instead of fixing that as gail implied with proper security, you are looking for a bandaid approach to limit by ip address.If you fix your security model by creating roles with the expected permissions, you gain twofold : a better security model and directly addressi g the overpriviledges problem while still fixing the problem itself[/quote]Actually 10 users are using a common User name & password to access the Application.. means all ten 10 users do DML operations on one application & we came across a scenario where some records were deleted from tables but god know who did that.. obviously that was the common Login ID used.. Its a client need..Client wants 10 users to use same Login ID but wants to know who did what incase of issue, like who deletes who makes updates & also wants that their should be no impact on server if we go ahaead & do some additional implementation on restrictions :w00t: :w00t::w00t:I am puzzled, my boss is puzzled :w00t: & team members are also puzzled :w00t:Tue, 27 Aug 2013 06:09:10 GMTOnlyOneRJRE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspx[quote][b]Jason.Reeves (8/27/2013)[/b][hr]Why would you be interested in the IP address if your using DNS and DHCP. Have a play withSELECT conn.session_ID as SPID,conn.client_net_address as IPAddress,sess.host_name as MachineName,sess.program_name as ApplicationName,login_name as LoginNameFROM sys.dm_exec_connections conninner join sys.dm_exec_sessions sesson conn.session_ID=sess.session_IDand triggers depending on the version of SQL you are using.[/quote]What will this query result??? please brief.. i ran it & got some records but what will i have to do next & read in it???:hehe:Tue, 27 Aug 2013 06:05:32 GMTOnlyOneRJRE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspxI suspect the core issue is that everyone logged in has sysadmin or dbo priviledges and instead of fixing that as gail implied with proper security, you are looking for a bandaid approach to limit by ip address.If you fix your security model by creating roles with the expected permissions, you gain twofold : a better security model and directly addressi g the overpriviledges problem while still fixing the problem itselfTue, 27 Aug 2013 04:54:31 GMTLowellRE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspxWhy would you be interested in the IP address if your using DNS and DHCP. Have a play withSELECT conn.session_ID as SPID,conn.client_net_address as IPAddress,sess.host_name as MachineName,sess.program_name as ApplicationName,login_name as LoginNameFROM sys.dm_exec_connections conninner join sys.dm_exec_sessions sesson conn.session_ID=sess.session_IDand triggers depending on the version of SQL you are using.Tue, 27 Aug 2013 02:51:05 GMTRandomEventRE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspxYes[quote][b]GilaMonster (8/26/2013)[/b][hr]It's called triggers and audits, along with properly configured security (minimal permissions)[/quote]Tue, 27 Aug 2013 02:42:49 GMTGilaMonsterRE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspxAnything for SQL 2008????Mon, 26 Aug 2013 22:10:30 GMTOnlyOneRJRE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspxIf I remember right MySQL has such features. One is able to specify different grants by IP addresses.Mon, 26 Aug 2013 10:57:17 GMTVille-Pekka VahtealaRE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspxIt's called triggers and audits, along with properly configured security (minimal permissions)Mon, 26 Aug 2013 03:59:26 GMTGilaMonsterRE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspxSo if I log into a coworkers computer using my own domain account, I can suddenly have more privileges because I'm using another IP? Awesome, this makes hacking so much easier :-DMon, 26 Aug 2013 02:56:09 GMTKoen VerbeeckRE: IP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspx48 viewed and 0 replies :w00t:Mon, 26 Aug 2013 02:32:39 GMTOnlyOneRJIP Restriction Featurehttp://www.sqlservercentral.com/Forums/Topic1488288-391-1.aspxThere should be a feature in database to allow only certain IPs to delete the data. Can we keep a log of the ip address when a record is deleted will help. Is their any solution for this.. please revert your expert advice:-)Mon, 26 Aug 2013 00:01:07 GMTOnlyOneRJ