Database table names

The 1C:Enterprise developers forum

#1
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Mar 1, 2021
Company: cognizant

Where do we find the user table name and and where exactly the user information is stored in 1C

 
#2
People who like this:0Yes/0No
Active user
Rating: 3
Joined: Mar 10, 2017
Company: Rufinor

Hello,

1C is using its onw ORM system which maps all 1C objects to database tables. For 1c developers it really doesn't matter which database table is used. We are not working directly with DB tables, we are using ORM to get access to information in tables. Given the fact that different database systems have different structures this is quite wise approach. All you need to know is what type of 1c object is representing the users class. In 1c we do have users class and you can find it in the 1c configuration mode under menu administration->users

Hopes this clarifies your question.
Alex

 
#3
People who like this:1Yes/0No
Just came
Rating: 1
Joined: Jan 17, 2023
Company: Techatom Pvt Ltd

In 1C: Enterprise, the user table is typically stored in the "Standard" configuration. The table name is "Users".

You can access the table by following these steps:

Open the "Configuration" menu in 1C: Enterprise and select "Designer" or "Configuration Designer" (Конфигуратор).

In the "Designer" or "Configuration Designer" window, navigate to the "Standard" configuration.

In the "Standard" configuration, navigate to the "Data Dictionary"and find the "Users" table.

You can now view the structure of the "Users" table and see its fields and properties.

It's important to note that this is the default table for users, the actual table name can be different if the system is customized. If the standard configuration is modified, it could be possible that the table name is different, in that case, you should check the system documentation or the developer to know the real table name.

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.