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 |
|
lslmustang
Starting Member
2 Posts |
 Posted - 2004-11-24 : 10:20:59
|
| I have a user who has access to the server and to several databases on the server, but is unable to view the list of DTS packages on this server.Public has access to msdb.sp_enum_dtspackages so I'm not sure why they are not seeing the list of packages in EM?Anyone have any ideas?Thanks,Linda |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-24 : 13:51:33
|
| I just created a user which only has public access to msdb and it can run sp_enum_dtspackages and see the dts packages in enterprise manager.It can also open the package which is a bit odd but...==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
lslmustang
Starting Member
2 Posts |
Posted - 2004-11-24 : 14:03:56
|
| I thought by default, without adding them to the public role for msdb they should be able to see them but for some reason, my users could not see them. I would love to find out why. I ended up adding permissions to the msdb database to the login they were a part of and now they can, but why couldn't they before? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-24 : 14:06:05
|
| EM must run other stored procs to get the listing. Run SQL Profiler to determine what it is doing.Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-24 : 18:52:51
|
| I did - it only ran sp_enum_dtspackagesI creates an sql server login with only access to msdb - no permissions just public, changed registrion in e-m to use that login and could view the dts packages - couldn't access any other database other than msdb.Maybe the login had something denied.Must admit I thought you had to be sa to view all packages but maybe that was something to do with the security at the company I was working at when I tried it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Viewing list of DTS packages