I'm working on moving our knowledge base application from an Access frontend/backend solution to a VB.Net frontend / MSDE 2000 backend solution. The MSDE database will be on a central server to which all users can access.
In the current application, the user is able to create private DBs and make it available on the network drive if they wish to share it. Since security is handled by the permissions of the folder in which the DB resides, this was not a major consideration in the current implementation. Now, I need to consider the NT/SQL security model for the migration and create procedures that will allow users to create application DBs and grant access to groups of users.
If anyone has done something similar and can provide some basic information or point me to an online example, I would be most appreciative.
Glen Appleton
VB.Net student.
In the current application, the user is able to create private DBs and make it available on the network drive if they wish to share it. Since security is handled by the permissions of the folder in which the DB resides, this was not a major consideration in the current implementation. Now, I need to consider the NT/SQL security model for the migration and create procedures that will allow users to create application DBs and grant access to groups of users.
If anyone has done something similar and can provide some basic information or point me to an online example, I would be most appreciative.
Glen Appleton
VB.Net student.