January 22, 2023 at 9:44 am
Sorry
Sp_helplogin output has been cutted in my picture.
The user has user in 1 more db
Full output
LoginName SID DefDBName DefLangName AUser ARemote
------------------------------------------ ---------------------------------------------------------------- ------------ -------------------- ----- -------
DMAR\mali 0x010500000000000515000000E37DC18CB054C61E3753525C01B40000 master us_english yes no
(1 rows affected)
LoginName DBName UserName UserOrAlias
--------------------------- ---------------- ---------------------- -----------
DMAR\mali DM_NA db_datareader MemberOf
DMAR\mali DM_NA DMAR\mali User
DMAR\mali DM_SND DMAR\mali User
(3 rows affected)
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply