Database Users Outsystems Database

Database Users Outsystems Database

  

Typically For each Platform Database account (Platform Admin, Runtime and Log) and also for the Platform Session Database account different user accounts are advised. What would be the disadvantage of having only one user for this? Any performance impacts? Others?

Solution

Hi Harry,

Security is the main issue. E.g., you do not want the runtime users changing the data model.

Those different database users have different privileges and thus should be separate users:

  • Admin user is the owner of the database catalog and can pretty much do anything
  • Runtime user have just the necessary privileges to just read and write data. That is the user used by all the applications.
  • Log user is used just for stuff related with logging (don't know much more about this one)

Cheers,

José

Solution

José Costa wrote:

Hi Harry,

Security is the main issue. E.g., you do not want the runtime users changing the data model.

Those different database users have different privileges and thus should be separate users:

  • Admin user is the owner of the database catalog and can pretty much do anything
  • Runtime user have just the necessary privileges to just read and write data. That is the user used by all the applications.
  • Log user is used just for stuff related with logging (don't know much more about this one)

Cheers,

José

Hi José,

Makes sense indeed, thank you.

Ciao,

Harry