Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Effected DB table when new user is created in confluence

Hi,

we are trying to integrate confluence with our access management tool and looking for below details which Atlassian is unable to provide.


At DB end is there any stored procedure available for user creation in the confluence application(If yes, kindly provide the name of procedure).

If not, please provide below details

1.List of affected tables while creating a new user in confluence.
2.How primary key ID is incrementing (is it by sequence or by any other approach).
3.In CWD_USER table what should be the value of column 'credential' and when it should get updated.

1 answer

1 accepted

0 votes
Answer accepted

Ok, I'll start with the standard points. 

  • Stop reading the database, it is not designed for you to report off
  • More importantly, you should almost certainly never be writing to it, so there's no need for you to ask any of these questions.

But, on to the answers to your questions:

>At DB end is there any stored procedure available for user creation

No.  Atlassian applications use databases as a data store, nothing more, they do not have stored procedures you would trigger or use, the logic is all done in the application

> List of affected tables while creating a new user in confluence.

Primarily the CWD_ tables, but it can affect others, depending on what you're doing, Apps and external directories.  The application logic will handle it for you if you do it properly.

> .How primary key ID is incrementing (is it by sequence or by any other approach).

It is sequenced, but it's done in non-single steps to avoid clashes.  You can not predict what the next sequence will be unless the system is completely shut down, then you'll be able to create what you want and make sure the sequence counter is above it.

> In CWD_USER table what should be the value of column 'credential' and when it should get updated.

It's the hash of the user's password for internal users and a flag for non-internal users.  It needs updating when an internal user changes their password.  It is a value that you should never touch, unless you are the user changing their password.

Hi Nic,

 

Thanks for the revert.

 

Actually it is mandatory to integrate our Access tool with confluence for user creation that's why we are looking for help. 

Can we create users from DB end by inserting DB queries or any other way to create users from using Web services or JSON approach.

Kindly help on this as this compliance issue at BANK.

If it's down to Compliance, I think your Compliance regulations would mandate you absolutely not touching the database...

What you do with this is up to how you are provisioning users.  I would strongly recommend not using Confluence's "internal" users, and hooking it up to your internal directory for a global list of users across various applications.  Your user directory is going to be already compliant, and the connection means you don't have to worry about Confluence users, you'll maintain them in the directory.  For a lot of directories, Confluence has support built in - if for example, you've got an LDAP one, click add directory, choose LDAP, give it the connection details and the rules for what users and groups to import and that's it.

If you do not use a directory, then you're going to need some scripting and code to manipluate the users.

Dear Nic,

will need more clarity on how we can create user using DB queries in database, we use LDAP as user directory .

Also, where we need to write code or scripting if DB queries dont work for user creation.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

37,757 views 27 124
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you