Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How to prevent modiflication of data from SSMS GUI Tool ?.

Proposed Answer How to prevent modiflication of data from SSMS GUI Tool ?.

  • Wednesday, February 06, 2013 5:22 AM
     
     
    Sign In to Vote
    0

    Hi,

    If some one Open table and Modified values .How would i prevent them from doing this ?.

    And also not with SSMS Query window

    1st thing is most important.

    -- Bhavesh Thakkar

    Sr.Database Administrator
    My Blog
    Linked In Profile

     

All Replies

  • Wednesday, February 06, 2013 5:34 AM
     
     
    Sign In to Vote
    0
    You may probably not give write access to the user. Thats the best choice.

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

     
  • Wednesday, February 06, 2013 5:48 AM
     
     
    Sign In to Vote
    0

    Oh..!!

    That is off topic.

    I prevent developers to not entry or changes from database

    because user connected through their login and entry of username logged in log table but it changed by ssms it will not right .

    we require only client changed data.

    -- Bhavesh Thakkar

    Sr.Database Administrator
    My Blog
    Linked In Profile

     
  • Wednesday, February 06, 2013 9:35 AM
     
     Proposed Answer
    Sign In to Vote
    0

    You last post is a bit unclear, but as said by Lateesh, you can only prevent people from changing data by denying them write access to the database. It doesn't matter if they connect through SSMS or an application - you'll still have to do it via security settings.

    Steen Schlüter Persson (DK)

     
  • Wednesday, February 06, 2013 9:55 AM
     
     
    Sign In to Vote
    0

    Oh..!!

    That is off topic.

    I prevent developers to not entry or changes from database

    because user connected through their login and entry of username logged in log table but it changed by ssms it will not right .

    we require only client changed data.

    -- Bhavesh Thakkar

    Sr.Database Administrator
    My Blog
    Linked In Profile

    You can only grant "Select" privilege on the tables to the developer users, but grant "Insert"/"Update"/"Select" privilege on the tables to other database users, who will access the tables through the systems.

    Many Thanks & Best Regards, Hua Min

     
  • Wednesday, February 06, 2013 9:59 AM
     
     
    Sign In to Vote
    0

    I want to prevent to use SSMS for updation.

    No other user.In User CAL.We already used all user.so please give us any other solution.

    -- Bhavesh Thakkar

    Sr.Database Administrator
    My Blog
    Linked In Profile

     
  • Wednesday, February 06, 2013 10:17 AM
     
     Proposed Answer
    Sign In to Vote
    0

    You can't prevent a user from updating data via SSMS if this user has write access to the database. The only way would be to prevent the user from installing SSMS at all, but I don't think that's the way to go...:-).

    Steen Schlüter Persson (DK)

     
  • Monday, February 18, 2013 6:20 AM
     
     
    Sign In to Vote
    0
    if i get the solution then make as answer..put as unanswered,,

    -- Bhavesh Thakkar

    Sr.Database Administrator
    My Blog
    Linked In Profile