SQL-Server-Permissions-Manager icon indicating copy to clipboard operation
SQL-Server-Permissions-Manager copied to clipboard

perms.restorePerms : sp_addrolemember need a parameter @rolename

Open wfreeman opened this issue 1 year ago • 0 comments

hi,

i install the script on master db, and exec a perms.snapshotEverything proc, which i assumed all the permissions would be save to a snapshot.

but when i try to exec perms.restorePerms 'somedb',

error occurs: ‘....sp_addrolemember need a parameter @rolename’

my sqlserver version is:

Microsoft SQL Server 2019 (RTM-CU14) (KB5007182) - 15.0.4188.2 (X64) Nov 3 2021 19:19:51 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Linux (Ubuntu 20.04.3 LTS) <X64>

wfreeman avatar May 11 '24 15:05 wfreeman