Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Geomeo
Starting Member
2 Posts |
 Posted - 2009-08-31 : 19:34:20
|
| Hi there, I'm slightly lost on setting up security for my SQL database. So far I've set up a website using Visual Studio asp.net and I've connected to the sql instance using the data connection string and everything works ok I can create a user and it shows up in my database table. If I add another table for images can I set up permissions on that table so that different users can see there images respectively? How would I go about that? Right now I think I'm connected to the instance of SQL and it's basically allowing access to everything. I think lol. Thanks for any help in advance. |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-09-01 : 08:31:20
|
quote:
Originally posted by Geomeo
Hi there, I'm slightly lost on setting up security for my SQL database. So far I've set up a website using Visual Studio asp.net and I've connected to the sql instance using the data connection string and everything works ok I can create a user and it shows up in my database table. If I add another table for images can I set up permissions on that table so that different users can see there images respectively? How would I go about that? Right now I think I'm connected to the instance of SQL and it's basically allowing access to everything. I think lol. Thanks for any help in advance.
It would be better to implement this at application level rather than at database level.. |
 |
|
|
Geomeo
Starting Member
2 Posts |
Posted - 2009-09-01 : 23:11:16
|
| Explain? |
|
|
|
|
|
|
Security for SQL