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 |
|
leydsonpontes
Starting Member
4 Posts |
 Posted - 2011-12-13 : 20:39:20
|
| Can anyone help for creation a role that don't permit a user access(view, modify, create) DTS in a SQL SERVER? The roles I created all permit user access DTS. Is there any Server Role for this?ThanksLeydson P. Ferreira |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-13 : 23:56:16
|
| where are the packages stored?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
leydsonpontes
Starting Member
4 Posts |
Posted - 2011-12-14 : 06:51:04
|
| At SQL Server.Leydson P. Ferreira |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-14 : 09:06:52
|
| what are roles the user is currently mapped to?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
leydsonpontes
Starting Member
4 Posts |
Posted - 2011-12-14 : 09:37:04
|
| roles "public", "db_datareader" and "db_denydatawriter"Leydson P. Ferreira |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-15 : 03:10:53
|
| then he wont be able to accces the packages stored inside server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
leydsonpontes
Starting Member
4 Posts |
Posted - 2011-12-15 : 09:22:10
|
| but he access this packages, can't modify and save with same name, but can save with another name and schedule jobs.Leydson P. Ferreira |
|
|
|
|
|
|
Server Roles