Code that be used to scripts to extract role permissions for a database for SQL authenticated accounts, it is useful when rebuilding a server and after databases are reattached the SQL authenticated users access has to be granted. DECLARE db_cursor CURSOR FORSELECT 'exec sp_addrolemember ''' + g.name + ''', ''' + sl.name + '''', sl.nameFROM … Continue reading Script to create grants to roles to database for SQL authenticated users.
Tag: sp_grantdbaccess