IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

View only MSSQL Server user Options · View
dimoss
Posted: Thursday, November 24, 2016 5:01:30 PM
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
vlad
Posted: Thursday, November 24, 2016 5:06:56 PM
Rank: Advanced Member

Joined: 12/13/2005
Posts: 2,856
Location: Mauritius
Are you able to save the data with Commit button?
dimoss
Posted: Friday, November 25, 2016 9:49:52 AM
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!
vlad
Posted: Friday, November 25, 2016 12:50:08 PM
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.
Users browsing this topic
guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.