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 |
|
Red5
Starting Member
3 Posts |
 Posted - 2013-07-30 : 08:21:00
|
| I am fairly new to creating new Users in SQL Server 2008 R2 and we use the Windows Log-In mainly.I have created a log-on to have access to one DB, so that they can import and export tables from SQL via MS Access 2007 without seeing SQL.the only way to do this is to allocate the User the Alter task, but that gives them lots of permissions I don't want them to have, is there anyway of restricting the log-on to do the work required but minimise ther access? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Red5
Starting Member
3 Posts |
Posted - 2013-07-31 : 02:54:33
|
| Thanks Tara. I will give that a go.Chris |
 |
|
|
|
|
|
SQL Log-Ons