Hi there,
I have this problem quite a while and i decieded to write a post.
I've created role in asp.net called Customers.
I've added in web.config
<location path="CustomerDetails.aspx">
<system.web>
<authorization>
<allow roles="Customers" />
<deny users="*" />
</authorization>
</system.web>
</location>
Now im using a dropdownList into FormView to get information about shippingregion which is table into sql express with the following code:
<asp
ropDownList Width="350px" ID="ShippingRegionDropDown"
runat="server"
SelectedValue='<%# Bind("ShippingRegion") %>'
DataSourceID="SqlDataSource1"
DataTextField="ShippingRegion"
DataValueField="ShippingRegionID">
</aspropDownList>
Im using as connectio sqldata source but the problem is whnever i go to customer details i got error SELECT permission denied on object 'ShippingRegion', database 'gorjan', schema 'dbo'
I dont know what user i should add to sql server express because there is register customer option on the web page anybody can help?
I have this problem quite a while and i decieded to write a post.
I've created role in asp.net called Customers.
I've added in web.config
<location path="CustomerDetails.aspx">
<system.web>
<authorization>
<allow roles="Customers" />
<deny users="*" />
</authorization>
</system.web>
</location>
Now im using a dropdownList into FormView to get information about shippingregion which is table into sql express with the following code:
<asp
ropDownList Width="350px" ID="ShippingRegionDropDown"runat="server"
SelectedValue='<%# Bind("ShippingRegion") %>'
DataSourceID="SqlDataSource1"
DataTextField="ShippingRegion"
DataValueField="ShippingRegionID">
</asp
ropDownList>Im using as connectio sqldata source but the problem is whnever i go to customer details i got error SELECT permission denied on object 'ShippingRegion', database 'gorjan', schema 'dbo'
I dont know what user i should add to sql server express because there is register customer option on the web page anybody can help?