Skip to Content (Press Enter)
2012-06-12 22-20-42
Harry Marrenga
254Views
2Comments
Solved
Database Users Outsystems Database
Question

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?

0
0
14 Mar 2018
Copy Link
2020-03-05 14-29-02
José Costa
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é

0
0
14 Mar 2018
Copy Link
2012-06-12 22-20-42
Harry Marrenga

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



0
0
15 Mar 2018
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.