Hello,

I am trying to make a dataset and am having a problem that may be related to user permissions. If anyone can help me understand what is going on, I would appreciate it.

Here is the code that generates the error, which I show below:

Dim cmUtilityTrailer As New SqlCommand("Select * FROM TrailerGrid ", cnWebDataUtility)
Dim daUtilityTrailer AS New SqlDataAdapter()
daUtilityTrailer.SelectCommand = cmUtilityTrailer
Dim dsUtilityTrailer As new DataSet()
daUtilityTrailer.Fill(dsUtilityTrailer)
Dim TrailerTable = dsUtilityTrailer.Tables(0).Rows

Here's the error (which seems to indicate that it does not get past the first line):

System.Data.SqlClient.SqlException: SELECT permission denied on object 'TrailerGrid', database 'WebDataControl', owner 'dbo'.

Thanks for any help.

Peter.