GPTip42day - SA vs. DYNSA

Frank Hamelly | MVP...

46,532 Super User 2025 Season 1

Like(0)

Report

What are the primary differences between SA and DYNSA users in GP?

1. SA is the SQL database system administrator and has full access to all databases on the SQL Server, including non-GP databases. DYNSA is the GP database administrator and has access to all GP databases only.

2. SA and DYNSA are both granted Power User roles automatically in GP Security.

3. SA is required for certain tasks such as initial system installation, payroll updates, and to administer some 3rd party applications. Generally speaking though, DYNSA can perform most of the security and maintenance tasks in GP that SA can.

4. From a SQL database security perspective, DYNSA should be used by your GP administrator for day-to-day administrative duties. SA use should be reserved for SQL administrators where possible to reduce the possibility of tampering in non-GP databases.

This was originally posted here.