method Fill - problem

[Pawel Blochowiak]

Hello Everybody

SqlConnection conn = new SqlConnection(str);

DataSet dataSet = new DataSet();
SqlDataAdapter dataAdap = new SqlDataAdapter("select * from Region", conn);

conn.Open();
dataAdap.Fill(dataSet, "Region");

I have porblem with method Fill. When i don't coment line with
dataAdap.Fill(dataSet, "Region"); in my browser appears error:

SELECT permission denied on object 'Region', database 'Northwind', owner
'dbo'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: SELECT permission
denied on object 'Region', database 'Northwind', owner 'dbo'.

Source Error:

Line 30:
Line 31: conn.Open();
Line 32: dataAdap.Fill(dataSet,"Region");
Line 33:
Line 34:


When line 32: is coment application is runnign corect:

thanks for all respond
'harry'

 

[Guest]

In order to select information from a table in a SQL Server database, the
user referenced in your connection string must have permissions to do so.
Contact your database administrator to set up that user account with select
permissions on the table. Hope this helps.

Richard

 

[Pawel Blochowiak]

thank you 4 your help
i thought about access to the data base, but my users haven't requirement
permissons

now is okay
by

 

[Patrick Olurotimi Ige]

Pawelku,
Its a security issue and adequate access to the Database.
Trzymanko
Patrick