Skip to content

Instantly share code, notes, and snippets.

@ydenissov

ydenissov/1c_reset_users.sql

Created January 10, 2023 09:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ydenissov/35ea47ed054884da90719346373f3717 to your computer and use it in GitHub Desktop.
Save ydenissov/35ea47ed054884da90719346373f3717 to your computer and use it in GitHub Desktop.
Download ZIP
Сброс пароля пользователя 1С если база Postgres
Raw
1c_reset_users.sql
ALTER TABLE v8users RENAME TO v8users_old;
UPDATE Params SET FileName = 'users.usr_old' WHERE FileName = 'users.usr';
// Открываем конфигуратор
DROP TABLE v8users;
ALTER TABLE v8users_old RENAME TO v8users;
UPDATE Params SET FileName = 'users.usr' WHERE FileName = 'users.usr_old';
// Правим нужного пользователя
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment