Click here to Skip to main content
14,665,550 members
Rate this:
Please Sign up or sign in to vote.
See more:
I have one table in SQL Server Database due to some reasons i don't want user to edit rows of table in edit mode

Is that possible to do?


What I have tried:

I have tried with Tools > options > SQL Server Object Explorer > Edit Top <n> rows Command to set with 1, But in this way it will have allow to edit that one record and even allow to add new records i edit mode.

That's not preferable way. Is there any other preferable way?
Posted
Updated 31-Jul-17 2:49am
Comments
Kornfeld Eliyahu Peter 31-Jul-17 8:35am
   
How exactly your users are getting into SQL Management Studio?
Tbs.User 31-Jul-17 8:39am
   
Over here user means my trainees and other employees. And I Gauss that not the concern is right? If you don't know the answer why you are wasting our times by this type of comments.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Got my answer from MSDN forum. 
If anybody need for it 
<a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cbc05300-923e-4796-ba29-44bac7c7b374/can-we-disable-tables-row-editing-in-edit-mode?forum=sqlsecurity">Can we disable table's row editing in edit mode?</a>[<a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cbc05300-923e-4796-ba29-44bac7c7b374/can-we-disable-tables-row-editing-in-edit-mode?forum=sqlsecurity" target="_blank" title="New Window">^</a>]
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100