How to connect alfresco database?

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Active Member

How to connect alfresco database?

Hi,

            How to connect alfresco database? and Where the user details are stored in alfresco database? How we can view all the user details from the database? If possible to add any new field in alfresco tables? 

Please advice.

Thanks,

Sumathi Baskaran.

2 Replies
Highlighted
Senior Member

Re: How to connect alfresco database?

Hi,

I think, the answer is in this link (same question): Alfresco Database 

Regards,

clv

Highlighted
Established Member

Re: How to connect alfresco database?

Hi

How to connect alfresco database?

 - Please refer Configuring databases | Alfresco Documentation  link

Where the user details are stored in alfresco database?

 - Alfresco has its own mechanism to store user information. Everything in Alfresco is treated like node, be it file, folder or user. when you create a user it makes entry in multiple tables, some of then are alf_authority, alf_node, alf_node_properties etc.
 

How we can view all the user details from the database?

 - Best way to see list of user is from alfresco share UI. however, you can check 'alf_authority' table to see list of user and group names.

If possible to add any new field in alfresco tables? 

 - It is not advisable to make change in Alfresco database directly. Alfresco provides set of APIs which will help you to achieve your requirement.