How to assign view privilege to DTS packages?

Question

How to assign view privilege to DTS packages?

SQL ORACLE

One Orange Chip

Points: 27807
More actions
November 20, 2006 at 1:22 pm

#69156

But users should not execute these packages.
Many thanks for any input in advance.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

CDBA Hall of Fame Points: 3266 More actions · Answer 1

Try to use password protection on the packages. Then the packages can not be altered/dropped by any one except owner or sa/db admin.

Regards

Utsab Chattopadhyay

CDBA

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 2

Is there any other approach beside assigning passwords to DTS packages? Using password on DTS packages is not our preference.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

Assign execute permission on sp_get_dtspackage to the users whom you want to open the packages. As long as they're not the package owner or a member of sysadmin, they won't be able to save changes.

Greg