I wrote a VFP application that accesses a SQL Server database. I initially set up permissions to use sa without a password. Everything was working just fine. Now I created another SQL Server Login and set the default database to my VFP application database. I granted no Server Roles but gave Database Access to the VFP application database. I then assigned Database roles for the login to every option (I checked them all). Then I went into the database and set the permissions for the user to checkmark every column under permissions (this took a LONG time). After this I changed the Connection in my VFP database to use the new login. Now when I try and browse a view, I get an access denied error. If I give the new login SQL Server Administration rights then I can browse the remote views just fine. I then went into my login account and gave Database access to master, model, msdb, and tempdb. This still didn't help.

I don't want to grant Administration rights because the user can do anything inside of SQL Server. I just want to give them full rights to the applicatin database. I must be dong something wrong. Please help.

Isabel