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 - 2001-01-08 : 18:59:23
|
Karnelia writes "Hi all,
I set my database until object level permissions and I want to transfer the database using DTS to another server (SERVER2) which has different user/group from what the first server (SERVER1) has.
For example, I set one of my own stored procedure to be executable only by GROUP1, and this group does not exist on SERVER2. When I use DTS to transfer di stored procedure, it will fail and give 'There is no such user or group 'GROUP1' error even if I have turned off all security options (Transfer database users and database roles, nt & sql server logins, and object level permissions).
But it only happens to stored procedures, it will be fine if I transfer tables or views that have object level permission.
I must first remove all the object level permissions on stored procedure and retransfer to make it work.
Anybody know how to transfer the data by DTS without the need to remove all object level permissions ?
Thanks,
Karnelia" |
|
|
|
|
|
DTS & object level permissions