I have an application that a user logs into using Windows authentication to connect to the database. Once in the application they are running a process that imports a file into the database. We have 3 users that have the appropriate permissions to perform this job function. This week and existing user of the application needed to be able to run the process. I had to give her the bulk_admin role initially and then when she ran the process she received:
"Database Error 1088: Cannot find the object "xxxxx" because it does not exist or you do not have permissions. "
Her login is identical to the other three users that are able to run the process. They are all part of the same database role which has permission to the table object being referenced in the error. If I give the user the ddladmin role for the database where the table resides then she is able to run the process. I am reluctant to do this though since none of the other three users have this database role.