>RightKey RoleKey UserKey RightName RightCode AllowDeny >----------- ----------- ----------- -------------------------------------------------- -------------------------------------------------- ----------- >27 NULL NULL Add User sys_add_user 1 >28 NULL NULL Edit User sys_edit_user 1 >29 NULL NULL Remove User sys_remove_user 1 >30 NULL NULL Lock User sys_lock_user 1 >>
insert into @Roles (RoleKey, UserKey, etc.) select 'SomeRole', UserKey, etc. from @Roles where RightKey = @RightKey