DBAdmin/journals/2026-05-14.md

type, title, date, tags, Status

type	title	date	tags	Status
DailyNote	Daily Note - 2026-05-14	2026-05-14 08:05:53		Active

Podsumowanie dnia

1. Zarządzanie uprawnieniami i dostępami (Access Management)

Większość Twojego dnia skupiała się na realizacji zgłoszeń dostępowych (SCTASK):

• SCTASK0740526: Potwierdziłeś nadanie uprawnień dla użytkownika Gagandeep Singh.
• SCTASK0740469 (dla Philippa Kunza): Utworzyłeś i skonfigurowałeś dostęp dla konta axeed_export_job. Użytkownik otrzymał rolę db_datareader w bazie Piccard_Business oraz dostęp do bazy SwissExtract_GSRL_7. Przeprowadziłeś również weryfikację uprawnień tego konta na serwerach 10.146.11.71 oraz 10.146.11.86.
• SCTASK0733968 (Philip Armin Hainz): Skonfigurowałeś dostępy dla kont domenowych BISNODE\hainz oraz BISNODE\eso9. Zostały im przypisane role db_owner w kilkunastu bazach danych (m.in. CERTIFICATES, CSAT_CZ, CSAT_SK, DRIFT, GBR_CZ, GBR_SK, OKBASE, UPGRADE_PRG, WORK, WORKDAY_CZ, WORKDAY_SK).

2. Konfiguracja i zadania administracyjne (Maintenance)

• SCTASK0727383 (CHMISFIDB0PRW01): Zaktualizowałeś konfigurację wysyłki e-maili systemowych. Ze względu na to, że Guido Mark odszedł z firmy, zmieniłeś adres nadawcy z jego indywidualnego na grupowy adres zespołu: dbetechops-monitoring@dnb.com.

3. Rozwój bazy wiedzy i narzędzi AI (Wiki LLM)

Sporą część dnia spędziłeś na intensywnej rozbudowie swojej bazy wiedzy (Wiki):

• Przetwarzanie i integracja nowych źródeł: Dodałeś notatki, koncepcje i podsumowania dotyczące m.in. Autoresearch, Software 2.0, narzędzi AI w pracy (Nanobanana workflow, Karpathy LLM Wiki) oraz problemów Accidental DBA.
• Tworzenie syntez: Stworzyłeś nową stronę z zestawieniem i porównaniem strategii automatyzacji AI.
• Prace strukturalne: Rozpocząłeś inicjalizację fundamentów Wiki LLM, wykonałeś "Feynman Check" dla nowych materiałów i zrefaktoryzowałeś schemat (w tym plik GEMINI.md).

Dzień był bardzo produktywny, łączący bieżące gaszenie biletów (BAU) z ważną pracą nad długofalowymi procesami i bazą wiedzy!

SCTASK0740526 Database User Access - Gagandeep Singh miał nadane uprawnienia

SCTASK0740469 Database User Access - Philipp Kunz USE [Piccard_Business] GO CREATE USER [BISNODECH\axeed_export_job] FOR LOGIN [BISNODECH\axeed_export_job] GO USE [Piccard_Business] GO ALTER ROLE [db_datareader] ADD MEMBER [BISNODECH\axeed_export_job] GO USE [SwissExtract_GSRL_7] GO CREATE USER [BISNODECH\axeed_export_job] FOR LOGIN [BISNODECH\axeed_export_job] GO on 10.146.11.71 user axeed_export_job has read access BisnodeJobAudit added read access to Piccard_Business SwissExtract_GSRL_7 on 10.146.11.86 user axeed_export_job already has access to db axeed_export_job

this is the same use because is in AD

SCTASK0733968 - Windows User Access - Philip Armin Hainz

USE [master] GO CREATE LOGIN [BISNODE\hainz] FROM WINDOWS WITH DEFAULT_DATABASE=[master] GO use [CERTIFICATES]; GO use [WORKDAY_SK]; GO USE [CERTIFICATES] GO CREATE USER [BISNODE\hainz] FOR LOGIN [BISNODE\hainz] GO USE [CERTIFICATES] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\hainz] GO use [CSAT_CZ]; GO use [CERTIFICATES]; GO USE [CSAT_CZ] GO CREATE USER [BISNODE\hainz] FOR LOGIN [BISNODE\hainz] GO USE [CSAT_CZ] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\hainz] GO use [CSAT_SK]; GO use [CSAT_CZ]; GO USE [CSAT_SK] GO CREATE USER [BISNODE\hainz] FOR LOGIN [BISNODE\hainz] GO USE [CSAT_SK] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\hainz] GO use [DRIFT]; GO use [CSAT_SK]; GO USE [DRIFT] GO CREATE USER [BISNODE\hainz] FOR LOGIN [BISNODE\hainz] GO USE [DRIFT] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\hainz] GO use [GBR_CZ]; GO use [DRIFT]; GO USE [GBR_CZ] GO CREATE USER [BISNODE\hainz] FOR LOGIN [BISNODE\hainz] GO USE [GBR_CZ] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\hainz] GO use [GBR_SK]; GO use [GBR_CZ]; GO USE [GBR_SK] GO CREATE USER [BISNODE\hainz] FOR LOGIN [BISNODE\hainz] GO USE [GBR_SK] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\hainz] GO use [OKBASE]; GO use [GBR_SK]; GO USE [OKBASE] GO CREATE USER [BISNODE\hainz] FOR LOGIN [BISNODE\hainz] GO USE [OKBASE] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\hainz] GO use [UPGRADE_PRG]; GO use [OKBASE]; GO USE [UPGRADE_PRG] GO CREATE USER [BISNODE\hainz] FOR LOGIN [BISNODE\hainz] GO USE [UPGRADE_PRG] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\hainz] GO use [WORK]; GO use [UPGRADE_PRG]; GO USE [WORK] GO CREATE USER [BISNODE\hainz] FOR LOGIN [BISNODE\hainz] GO USE [WORK] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\hainz] GO use [WORKDAY_CZ]; GO use [WORK]; GO USE [WORKDAY_CZ] GO CREATE USER [BISNODE\hainz] FOR LOGIN [BISNODE\hainz] GO USE [WORKDAY_CZ] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\hainz] GO use [WORKDAY_SK]; GO use [WORKDAY_CZ]; GO USE [WORKDAY_SK] GO CREATE USER [BISNODE\hainz] FOR LOGIN [BISNODE\hainz] GO USE [WORKDAY_SK] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\hainz] GO

Msg 15025, Level 16, State 2, Line 3 The server principal 'BISNODE\hainz' already exists. Msg 15023, Level 16, State 1, Line 11 User, group, or role 'BISNODE\hainz' already exists in the current database. Msg 15023, Level 16, State 1, Line 23 User, group, or role 'BISNODE\hainz' already exists in the current database. Msg 15023, Level 16, State 1, Line 35 User, group, or role 'BISNODE\hainz' already exists in the current database. Msg 15023, Level 16, State 1, Line 47 User, group, or role 'BISNODE\hainz' already exists in the current database. Msg 15023, Level 16, State 1, Line 59 User, group, or role 'BISNODE\hainz' already exists in the current database. Msg 15023, Level 16, State 1, Line 71 User, group, or role 'BISNODE\hainz' already exists in the current database. Msg 15023, Level 16, State 1, Line 95 User, group, or role 'BISNODE\hainz' already exists in the current database. Msg 15023, Level 16, State 1, Line 107 User, group, or role 'BISNODE\hainz' already exists in the current database. Msg 15023, Level 16, State 1, Line 119 User, group, or role 'BISNODE\hainz' already exists in the current database. Msg 15023, Level 16, State 1, Line 131 User, group, or role 'BISNODE\hainz' already exists in the current database.

Completion time: 2026-05-14T11:34:39.8589764+02:00

USE [master] GO CREATE LOGIN [BISNODE\eso9] FROM WINDOWS WITH DEFAULT_DATABASE=[master] GO use [CERTIFICATES]; GO use [WORKDAY_SK]; GO USE [CERTIFICATES] GO CREATE USER [BISNODE\eso9] FOR LOGIN [BISNODE\eso9] GO USE [CERTIFICATES] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\eso9] GO use [CSAT_CZ]; GO use [CERTIFICATES]; GO USE [CSAT_CZ] GO CREATE USER [BISNODE\eso9] FOR LOGIN [BISNODE\eso9] GO USE [CSAT_CZ] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\eso9] GO use [CSAT_SK]; GO use [CSAT_CZ]; GO USE [CSAT_SK] GO CREATE USER [BISNODE\eso9] FOR LOGIN [BISNODE\eso9] GO USE [CSAT_SK] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\eso9] GO use [DRIFT]; GO use [CSAT_SK]; GO USE [DRIFT] GO CREATE USER [BISNODE\eso9] FOR LOGIN [BISNODE\eso9] GO USE [DRIFT] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\eso9] GO use [GBR_CZ]; GO use [DRIFT]; GO USE [GBR_CZ] GO CREATE USER [BISNODE\eso9] FOR LOGIN [BISNODE\eso9] GO USE [GBR_CZ] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\eso9] GO use [GBR_SK]; GO use [GBR_CZ]; GO USE [GBR_SK] GO CREATE USER [BISNODE\eso9] FOR LOGIN [BISNODE\eso9] GO USE [GBR_SK] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\eso9] GO use [OKBASE]; GO use [GBR_SK]; GO USE [OKBASE] GO CREATE USER [BISNODE\eso9] FOR LOGIN [BISNODE\eso9] GO USE [OKBASE] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\eso9] GO use [UPGRADE_PRG]; GO use [OKBASE]; GO USE [UPGRADE_PRG] GO CREATE USER [BISNODE\eso9] FOR LOGIN [BISNODE\eso9] GO USE [UPGRADE_PRG] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\eso9] GO use [WORK]; GO use [UPGRADE_PRG]; GO USE [WORK] GO CREATE USER [BISNODE\eso9] FOR LOGIN [BISNODE\eso9] GO USE [WORK] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\eso9] GO use [WORKDAY_CZ]; GO use [WORK]; GO USE [WORKDAY_CZ] GO CREATE USER [BISNODE\eso9] FOR LOGIN [BISNODE\eso9] GO USE [WORKDAY_CZ] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\eso9] GO use [WORKDAY_SK]; GO use [WORKDAY_CZ]; GO USE [WORKDAY_SK] GO CREATE USER [BISNODE\eso9] FOR LOGIN [BISNODE\eso9] GO USE [WORKDAY_SK] GO ALTER ROLE [db_owner] ADD MEMBER [BISNODE\eso9] GO Commands completed successfully.

Completion time: 2026-05-14T11:35:37.1466569+02:00

SCTASK0727383 - General Database Request - CHMISFIDB0PRW01 Please change the e-mail sender from markgu@dnb.com to an active e-mail address because Guido Mark had to leave the company. -> zmieniłem na nasz ogólny dbetechops-monitoring@dnb.com