Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Master Files & Security Access to database
Message
From
16/04/2010 08:25:19
 
 
To
15/04/2010 13:20:18
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
01460350
Message ID:
01460511
Views:
22
I've sorted out the display problem, but am still stuck with the security issue.

>2. Security access to the database. As soon as I tried to login I got a message about my ASPNET use not having access to the database, so I added that user in SSMS and added them to the db_datareader role. This worked, but then when I needed to make changes to the data it failed, so I added them to the db_datareader role. However, it does not work when my stored procedures get called:
>
>Exception Details: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'ClientsSelectByNumberOrName', database 'SIAS', schema 'dbo'.
>
>Does this mean that I need to go through each stored proc one by one and add Execute rights?

My user that the web site seems to be using is SAMAAN\ASPNET.

I have created a schema called db_ASPNET and tried code like this in SSMS:

GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE
ON SCHEMA::db_ASPNET TO SAMAAN\ASPNET

but I get a syntax error pointing at the "\". How do I get this to work?
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform