Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    1

    Unanswered: How to create a read only user for DTS

    Hi,

    i need a help to create read only user. the user needs to read all the DTS packages also. but the new user should not change any DTS packages.

    How can achive it. pease help me.

    Regards,
    Karthi B

  2. #2
    Join Date
    Jan 2010
    Location
    Alaska
    Posts
    3
    What version of SQL? I am going to assume SQL 2000?

    Create the user under security, select what databases you want them to have access to... make them a public user along with dbdatareader permissions. If they have the correct tools they should be able to view the jobs, but not change anything.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •