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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
nothing wrong with db
ended up being an application bug