HomeForum
Welcome, Guest

Question concerning SQL access
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Question concerning SQL access

Question concerning SQL access 1 year, 4 months ago #1341

  • Cliff
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • 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

Re: Question concerning SQL access 1 year, 4 months ago #1342

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2174
  • Karma: 12
No need to use sa permissions
db_owner should do

Peter
  • Page:
  • 1
Time to create page: 0.14 seconds

Testimonials

Well this great product and I’ve ever seen …. Yet.

Inexpensive
User friendly
Trusted and Reliable
Best features
Great support
Very fast and best performance
Recommend for all groups (small, medium, large / enterprise)

C Gandhi
Nesa-Canada

User Login

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



Our customers

BP

BBC

HSBC


Databases we work with

Go to top