January 21, 2023 at 2:56 pm
Hi,
fn_my_permissions show me grant 'insert' for db user but I couldn't find who is grantor.
It looks it's granted from the schema on the whole , where table is located .
database_permissions and sp_helprotect couldn't help me. Can it be hidden for sysadmin ?
See attach with output.
Thank you in advance for your help
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply