use testdb;
use [testdb] exec sp_changedbowner mssql;

CREATE ROLE [LompeKnutRole];ALTER ROLE [LompeKnutRole]    -- Samme navn som database-bruker
ADD MEMBER [LompeKnutDB]
GO

execute as user = 'LompeKnutDB';
select * from meat;
revert

GRANT SELECT TO [LompeKnutRole];
deny SELECT TO [LompeKnutRole];