January 7, 2009 at 5:49 am
Im building a website and admin/cms system using .net 3.5 (c#)
The site is hosted and Ive been given 2 logins, one for sa, the other a general login
the sa login is in the public and sysadmin roles and the general login is in the public role
what do I have to do to allow the general login access to the tables and stored procedures ? Im also using roles and membership so how do i allow access to the tables & sp's for this also ?
Shoulk I create a custom role for the general login ? Im a bit nervous assigning eveything to the public role as there are other databases on the shared server which would be assigned to the public role.
Could anyone point me in the direction of a step by step guide for database access and .net sites ?
January 7, 2009 at 11:00 am
You definitely want to use a database role to grant permissions and then put your login/user in the role.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply