DTS AUTHORIZATIONS
-
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!!
-
By default, if someone has quest access to msdb, they can create a package. It basically requires insert to sysdtspackages in msdb.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com -
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
-
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
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply