HomeForum
Welcome, Guest
ETL-Forum
Forum
Advanced ETL Processor

Minimum permissions to run ETL processes
(1 viewing) (1) Guest
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: Minimum permissions to run ETL processes

Minimum permissions to run ETL processes 1 year, 2 months ago #1715

  • Craig
  • OFFLINE
  • Fresh Boarder
  • Posts: 12
  • Karma: 0
Hi there

We have been setting up and use sa access for the MS SQL access, however the question has been raised by the client that their policy is to use specific accounts rather than sa access.

What are the minimum the minimum permissions that such an account would require for the ETL still to work?

Regards,
Craig
Reply Quote

Re: Minimum permissions to run ETL processes 1 year, 2 months ago #1716

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
Well sa permissions are not really needed dbowner should be enough to run
Advanced ETL processor

Peter
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Advanced ETL Processor
Powered by Kunena
Time to create page: 0.14 seconds

Testimonials

Visual Importer ETL  saved us 25-30 hours per month. Much of that comes from being able to build in error checking into the scripting. I've even been able to script corrections that run on the fly triggered by the error checking on incoming order files.

Gene Kovacs,
Director of Technical Business Operations,
A2B

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC

Databases we work with

Submit to Delicious Submit to Digg Submit to Facebook Submit to Google Bookmarks Submit to Stumbleupon Submit to Technorati Submit to Twitter Submit to LinkedIn
Go to top