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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-08 : 09:12:35
|
Anne writes "Recently we moved our database from Access 97 to SQL Server 7.0. Now we use Access only as a frontend. My question is this: How shall permissions be dealt with in SQL server? As there already is a permission structure in Access and no user has the same permissions as another user (although they all are members of the same group so they may access the database in the first place), how should I deal with the permissions in SQL? Even if I create a group called "England" for example, would not the user be prompted twice for a password since he is joining a new group in the SQL server? Is there an easy way to port over exisiting permissions from Access to SQL without having to individually put in each one? My last SQL instructor said you could use the same permissions in Access to delegate the SQL permissions...but then if you have no permisssions at all set up on the SQL server, then you cannot access it and therefore it is useless. What would you suggest?
Thank you very much
Anne" |
|
|
|
|
|
SQL security permissions