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 ««12

IP Restriction Feature Expand / Collapse
Author
Message
Posted Tuesday, August 27, 2013 6:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
Lowell (8/27/2013)
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


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
I am puzzled, my boss is puzzled & team members are also puzzled








************************************
Every Dog has a Tail !!!!!
Post #1488705
Posted Tuesday, August 27, 2013 6:27 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 AM
Points: 42,467, Visits: 35,535
Once 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.




Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1488712
Posted Tuesday, August 27, 2013 6:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
Gail, 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 implement








************************************
Every Dog has a Tail !!!!!
Post #1488720
Posted Tuesday, August 27, 2013 6:43 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 AM
Points: 42,467, Visits: 35,535
Try Books Online (the SQL help file). It has pages and pages on both.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1488722
Posted Tuesday, August 27, 2013 6:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
Sure Gail, Incase of any query i will reply here.. thanks for Update







************************************
Every Dog has a Tail !!!!!
Post #1488734
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse