|
Rank: Newbie
Joined: 11/24/2016 Posts: 6
|
Hi
I downloaded the DatabaseSpy 2017 PRO ver. to test it locally. I have created a view only SQL user in my MSSQL Server 2012 and I use this user to connect to the db via DatabaseSpy. Everything is ok and I connect using the Native SQL client. The problem is that I am still able to edit the data of the db tables while I shouldn't! Using the same user to connect using SQL Server Management Studio I can only SELECT and not UPDATE as it should be. Am I missing something?
Thanks
|
|
Rank: Advanced Member
Joined: 12/13/2005 Posts: 2,856 Location: Mauritius
|
Are you able to save the data with Commit button?
|
|
Rank: Newbie
Joined: 11/24/2016 Posts: 6
|
vlad wrote:Are you able to save the data with Commit button?
Yes I am able and that is weird.
This happens only if I connect using the SQL Native Client 11 option because if I make the connection through a normal connection string using ADO.NET everything works as expected which means the uses hasn't edit rights!
|
|
Rank: Advanced Member
Joined: 12/13/2005 Posts: 2,856 Location: Mauritius
|
Well then I would guess that something is wrong on SQL Server side, because the server must not allow any changes, no matter which tool you use.
|
|
guest |