Link to home
Create AccountLog in
Avatar of glenn_r
glenn_r

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?
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of glenn_r
glenn_r

ASKER

the above all check out
nothing wrong with db
ended up being an application bug