Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Master Files & Security Access to database
Message
De
16/04/2010 08:25:19
 
 
À
15/04/2010 13:20:18
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Divers
Thread ID:
01460350
Message ID:
01460511
Vues:
23
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform