Recommended SQL Account privileges for HEAT Classic.

Version 1

    Details

    Recommended SQL Account privileges for HEAT Classic.


    Resolution

    Db_Owner is preferred for the HEAT account because this will allow the Administrator user the ability to drop and rebuild objects in the DB which is a requirement for the process of committing Edit Sets.  

    This also ensures proper table ownership at all times as they will all be owned by dbo, as object generation will take on the ownership of the account building the object.

    At minimum, the HEAT Admin user should be using a db_owner SQL account in order to do his/her job.

    The remaining HEAT users could use another account with more limited rights, just ensure they have SELECT, INSERT, UPDATE and DELETE rights to all tables in the HEAT database.