Create separate migration user for Prod DB

gaepdit / complaint-tracking

Complaint Tracking System

The Unlicense

1 stars 3 forks source link

Create separate migration user for Prod DB #800

Closed dougwaldron closed 3 months ago

dougwaldron commented 3 months ago

Please create separate DB accounts on the production "ComplaintTracking" database for cts_app_user with only DML rights and cts_migrations with DDL rights (plus select and insert). The changes should be the same as what was recently done on Dev (#738) and UAT (#767). Please keep the password for cts_app_user unchanged.

afatima16 commented 3 months ago

@dougwaldron requested is completed. Please verify at your connivence. for cts_migrations password https://github.com/gaepdit/app-config/blob/main/sql-server-accounts.md

dougwaldron commented 3 months ago

Everything looks good 👍🏼