asked on
can't write to sql server table says i don't have sufficient permission
Have the following
sql server db with several tables
vb.net program using ado.net to perform CRUD operations on the tables
i have 100's of customer using the app with no issues
this one particular client cannot write to a certain table
says i don't have permission
the login used in the connection string is a systemadmin
table permission does not seem to be overridden
i've dropped the table and recreated it and that works
migrating the data out of this database into a blank one that works is my backup plan but before that i'd like to attempt to fix it.
any advice?
sql server db with several tables
vb.net program using ado.net to perform CRUD operations on the tables
i have 100's of customer using the app with no issues
this one particular client cannot write to a certain table
says i don't have permission
the login used in the connection string is a systemadmin
table permission does not seem to be overridden
i've dropped the table and recreated it and that works
migrating the data out of this database into a blank one that works is my backup plan but before that i'd like to attempt to fix it.
any advice?
Microsoft SQL ServerVisual Basic.NET
Last Comment
glenn_r
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
nothing wrong with db
ended up being an application bug