Sharing a SQL database
-
Hi I`m running a simple application that acts as a portal for users to go to various sites such as Gmail and Facebook. I have a SQL database running in the background where I store all user passwords etc. At the moment, users access this application from 2 computers, meaning there are 2 databases. Thus, if a user updates his/her details on the one computer, it does not get reflected in the other database. Is there a way I can share a single SQL database between these 2 client computers? They are connected over a network.
-
Hi I`m running a simple application that acts as a portal for users to go to various sites such as Gmail and Facebook. I have a SQL database running in the background where I store all user passwords etc. At the moment, users access this application from 2 computers, meaning there are 2 databases. Thus, if a user updates his/her details on the one computer, it does not get reflected in the other database. Is there a way I can share a single SQL database between these 2 client computers? They are connected over a network.
Etienne_123 wrote:
Is there a way
Yes, it's called SQL Server after all. However, I don't think storing passwords is a good idea.
-
Etienne_123 wrote:
Is there a way
Yes, it's called SQL Server after all. However, I don't think storing passwords is a good idea.
Thanks. Just wanted to know before I started searching all over. I`m encrypting the passwords before storing them in the database though. Plus, its a prototype application run at an old age home, so security isn't my main priority, user-friendliness is.
-
Thanks. Just wanted to know before I started searching all over. I`m encrypting the passwords before storing them in the database though. Plus, its a prototype application run at an old age home, so security isn't my main priority, user-friendliness is.
If you are in the United States and "old folks home" qualifies as Health Care which means the data you are accessing, storing, and retrieving falls under HIPPA which is security intensive.
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost
-
If you are in the United States and "old folks home" qualifies as Health Care which means the data you are accessing, storing, and retrieving falls under HIPPA which is security intensive.
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost
Ahem; HIPAA. But it only applies to health-related data; I don't think it applies to email passwords.
-
Ahem; HIPAA. But it only applies to health-related data; I don't think it applies to email passwords.
Ahem: he is writing software for an "old people's home", copying and pasting SQL Server database's and relying on storing email passwords in a database. Does any part of this not set off data security alarms? My post was a polite reminder that there are legal repercussions for such a cavalier attitude towards data security.
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost
-
Ahem: he is writing software for an "old people's home", copying and pasting SQL Server database's and relying on storing email passwords in a database. Does any part of this not set off data security alarms? My post was a polite reminder that there are legal repercussions for such a cavalier attitude towards data security.
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost
Ennis Ray Lynch, Jr. wrote:
set off data security alarms
Absolutely, as I mentioned in my first post, but I don't think HIPAA is involved. I had a class on HIPAA last month. It's more a common sense issue -- don't write down passwords... anywhere. Especially where others can get them. And don't trust a third party to keep them safe.