Where Alfreso User Details are stored i Alfresco Database?

[himadribiswal]

Where the alfresco user details are stored in which table when alfresco is connected to MySQL Database?
How we can view all these user details from the Database?

Can anyone help regarding this?


Thanx.
Himadri

[mrogers]

The user details are stored as a Person Node within Alfresco.

You won't find anything as obvious as a "person" table.

[himadribiswal]

Thanx mrogers.

I have already connected my Alfresco to  database named Alfresco in  MySQL And I alfresco has 73 tables within it.
can you please tell me in which table the user info(i.e. username,passsword,email id etc…) are stored?

Can we create a user from the backend by entering some value in that particualr row in that table and login to the alfresco using the same credentials?


Thanx
Himadri

[mrogers]

No.   You don't touch the alfresco database.  Its implementation is private to Alfresco and changes from time to time.   Accessing the DB directly is also likely to upset Alfresco's normal running and bypass lots of Alfresco functionality such as rules and policies.

The only tables that are designed for access are the audit tables. 

What you should do to create a person is ie either use an external authentication service (e.g. NTLM or Kerberos) and let alfresco deal with the synchronisation.   Or use the alfresco person service.   Or use the alfresco node service.

[nirvanvjain]

Dear mrogers,

First of all I am very new to Alfresco. I don't know Lucene/XPath too .

I understood that all user information goes to Alfresco User Store and that is accessible using Lucene/XPath Query.

But When Alfresco Stores document (Content),it must store all information (metadata) related to it some where in database table as Alfresco store everything (metadata) in database.

Which all are tables having meta data information ?

Does Alfresco maintain search Audit (that what all search happen by particular user(s))?

Can we find out Last login in Alfresco (through any thing like System Information/Node Browsers) ?

Alfresco 3.4.x Supports rating then where all Rating data goes in to the database ?

Thanks!
-Nirvan

[mrogers]

As I said above you don't touch the database since that's the private implementation of Alfresco.

You can configure audit of who does what.   I don't know how to do it myself since its not something I know about. :mrgreen:

[nirvanvjain]

Dear All,

As from the above thread I understood that not to touch Alfresco's database.

But I want to create custom (my own) table in Alfresco database and want to store data from Alfresco

e.g. If I want to store all Search keyword along with User ID in to the database and want to access those details at later stage then

Is it Possible or say Good practise to create custom table in Alfresco Database ?

Can we fill (enter) data in to that table through Alfresco APIs ?

Is it possible that our custom Java Code can also get (access) those details ?

Thanks!
-Nirvan

[mrogers]

No its not good practice to access the database.    Some advanced users will do it but hopefully they know what they are doing :roll:   If you store data in database tables then you will have none of the alfresco functionality.

What is normal is to add properties, aspects, behaviours to your nodes within alfresco.   You can then search and retrieve those nodes.

There's also the "preferenceService" that's used to persist users' preferences, this may be what you are looking for.

[anurag03]

Hi ,

Please let me know in which table when we create User through api/people gets Stored in alfresco i want to know the table where information like username password group email id gets Stored?