first time MS SQL Server user issue

[dlacloche]

I've built an application but I'm getting some weird permissions error message.
Can someone read thru it and offer any suggestions? What does it all mean??!? :(

Server Error in '/' Application.
--------------------------------------------------------------------------------

SELECT permission denied on object 'Page', database 'Finpubsrv', 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 'Page', database 'Finpubsrv', owner 'dbo'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException: SELECT permission denied on object 'Page', database 'Finpubsrv', owner 'dbo'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader() +42
WoodComm.Page_List.Get_Page_DDL(Int32 ThisPage) +118
WoodComm.Page_List.Page_Load(Object sender, EventArgs e) +239
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2407

[BrainDonor]

make sure the user account you're using to connect to the db has permissions to do selects from the tables. to do this, go into MSSQL Management Studio (if you have it - otherwise a DBA might) and right click on the database you're connecting to...from there go to properties, then click on permissions. check to make sure that user exists and has access to do selects from the db. that's the best I can offer. hope it helps.

[russell]

or can explicitly grant permission

GRANT SELECT on [PAGE] to [USERNAME HERE]