Hi,

What permission needs regular users to execute the SP?

I'm receiving error: "Invalid object name '##tmpHtml2'." with regular users and with users within the db_owner group.

The only way I can execute...

works great with the function as was posted.

I just added double quotes on the line #92:

set @s-2 = @protect_type_name + ' ' + @action_name + ' ON '...

Andy Warren

...For applications I prefer that the connection be done using a single service account (unless we need a separate one that will be for read only) and I load...

Another way to do this is using Indentity, not using it as a property of a column, but as function in a TSQL statement. Using your example:

select Identity(int,1,1)...