New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

perms.restorePerms : sp_addrolemember need a parameter @rolename #4

Open

wfreeman opened this issue May 11, 2024 · 0 comments

wfreeman commented May 11, 2024

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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment