0 Comments

Users are in our case always a member of some role. The role is given exec stored procedure rights and db_datareader, db_datawriter rights.
Users in the role “TestRole” can select, insert, update, delete data and execute storedprocedures and functions.

if not exists (select 1 from dbo.sysusers su (nolock) where su.issqlrole = 1 and su.[name] = 'TestRole')
begin
    create role TestRole
    grant execute to TestRole
    exec sp_addrolemember db_datareader, PegasoServiceRole
    exec sp_addrolemember db_datawriter, PegasoServiceRole
end

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts

PowerShell – Negate boolean – use -Not

  https://stackoverflow.com/questions/8095638/how-do-i-negate-a-condition-in-powershell     function FolderExists {     param($folder)       $folderExists = Test-Path "$($folder)"     If ($folderExists -eq $True) {         Write-Host "Folder [$($folder)] exists."…