Ive been trying to get some type of Blogpost tutorial Etc on how to set up SQL Server 2005 to serve data to a website
1 How do I setup users?
a) Can I have 3 roles?
1a) Owner of DB can read/write
2a) reader Can Only read from database
3a) Writer. Can only write to database
How would I set this up? How can I call all these from ASP.NET depending on what the user is currently using on the website?
eg:
Just serving pages with content (reader)
Forms (writter)
admin (owner)
I also need to have the SQL keep sessions (Ive already ran aspnet_reqSQL.exe) and created all that im just unsure what type user can access all this
Any tutorials on how to set up a whole WEb application project from DB to VS 2005?
Thanks
Bump
No one knows how to correctly setup SQL Server?
|||So no one know how to setup SQL Server 2005 efficiently and securely???????
*Sight*
a) Can I have 3 roles?
1a) Owner of DB can read/write2a) reader Can Only read from database
3a) Writer. Can only write to database
After you have installed sql server,you can create some user accounts and assign them permissions as you like. Open sql server-> select one database and expand-->select "security"--> click "Users" or "Roles"
sql
No comments:
Post a Comment