topic Where the User data Stored in Alfresco. in Alfresco Archive

Where the User data Stored in Alfresco.

lmanoh — Wed, 12 Nov 2008 10:20:49 GMT

Hi, im new to alfresco,I installed alfresco Lab 3 and configured with Oracle 10g. now i created a new user with first name, Last name and email id.Now my question is where this data has been stored? whether in DB or file system?because i searched in DB, i could not found any data like username and

Re: Where the User data Stored in Alfresco.

madhu2710 — Fri, 21 Nov 2008 06:14:33 GMT

Hi lenin

Have u searched the content store in alf_data(in root directory). This data is stored in .bin format which could be traversed respectively the folders in datewise, but the file name is a random alpha-numeric.All the files (xml,doc,gif…)are stored respectively in .bin files only.

You can see users created in alf_authority table data in oracle 10g.

Re: Where the User data Stored in Alfresco.

pankaj_p_mishra — Thu, 21 Oct 2010 10:03:54 GMT

Hi All,

I am also suffering from same problem,when i submit user data .
could you please tell me in which table that information stored.
:?: :?: :?: :?: :?: :?: :?: :?:

Re: Where the User data Stored in Alfresco.

ssaravanan — Thu, 21 Oct 2010 10:38:55 GMT

Native Alfresco authentication system is what you get out of the box, which stores username and password in the DB.
But it could be configured with external systems refer
http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems
http://wiki.alfresco.com/wiki/Security_and_Authentication
Alfresco is a Document Management system, so the focus is more on DM rather than user management.
select * from alf_authority where authority like '%ss%'; will show the users…
DB is totally abstracted , and hardly we run sql queries as Alfresco provides
a rich interface for managing quite a lot of things.