What security level credentials need to setup for the primary and secondary data

thanks Sathya -- is there a general user ID to connect to the databased from Appian? IE should this be setup with DB owner access? Also you mention user if a user creates a table(CDT) in Appian does it create it based on the users credentials for the specific user or is it to the general user ID user to connect?

thanks Sathya -- is there a general user ID to connect to the databased from Appian? IE should this be setup with DB owner access? Also you mention user if a user creates a table(CDT) in Appian does it create it based on the users credentials for the specific user or is it to the general user ID user to connect?