Confluence users

[Islam]

Hey!

I have 2 servers with confluence, they look at the same schema in the database, tell me, can I determine through the database which user belongs to which confluence?

[Islam]

Can 2 Confluence services look at the same schema in the database? If so, how can I differentiate between users?

[Kishan Sharma]

Hi @Islam 

If you have access to the database, just run below query directly to see if the user exists in the DB -

select * from CWD_USER where USER_NAME = '1234'

[Islam]

I looked at the CWD_USER table, the bottom line is that 2 different confluence looks at the same scheme, can I separate users? How can I find out which user is using which of the two confluence?

[Islam]

If I create a new schema in the database and write it in the confluence configuration, when restarting, will the database be filled automatically?

[Kishan Sharma]

Regarding your first question - If the 2 different confluence instances are using same schema, that means that CWD_USER table will have same number of users in them.

For second question - if you create a new schema, it will be blank, and during the startup confluence will create required tables and the database will be filled based on the user activities in the application after the startup.