db_Owner property 1

[bashboy]

I have an app that is returning error of "SELECT permission denied on object '***', database '***', owner 'dbo'". The only way for me to get around this that I have found is to make the database login have the database access role of db Owner true....I would prefer not to do this, but am not sure how to get around this. Our program requires a login upfront to access the program and runs a bunch of select statements upon login.....I am assuming that something in my code on the selects is off, but I guess I'm not smart enough to find out what it is.

Any help that you can offer would be greatly appreciated.

 

[tlbroadbent]

You should be able to Grant Select On the table to the user.

GRANT SELECT ON dbo.tblname TO UsrName
Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost