DTS AUTHORIZATIONS

Question

DTS AUTHORIZATIONS

carolina garcia

Mr or Mrs. 500

Points: 537
More actions
August 24, 2004 at 6:22 am

#83708

Need Help..plis?

How can I grant a user in order to created DTS? What type ow permissions does he needs?

Thank you so much!!

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

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

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

By default, if someone has quest access to msdb, they can create a package. It basically requires insert to sysdtspackages in msdb.

carolina garcia Mr or Mrs. 500 Points: 537 More actions · Answer 2

Thank yo su much for your response Steve.

So, let's say that someone is an owner of a new database (IDBDOCS) and the userid is idbdocs_user, so, in order for him to created DTS I have to grant idbdocs_user to be write/read to the msdb database also?

Thank you so much for your help

PS. Is obvious to say that I am a new dba in Sql SErver

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

The only reason you'd have to explicity grant permissions to idbdocs_user is if you had removed permissions from the guest user and public role in msdb.

By default, guest is a member of the public role and public has permission to execute the stored procedures that create, drop , etc. DTS packages.

You can look up guest and public in Books on Line.

Greg