TRIGGER_NESTLEVEL And Limited Users

I want to use TRIGGER_NESTLEVEL to test if a specific trigger is on the execution stack.

Normally, the table with the trigger is accessed by stored procedures and the user does not have any direct access to the table.

I am having problems doing this because I need to use OBJECT_ID to get the ID to pass to TRIGGER_NESTLEVEL. OBJECT_ID is unable to see the table when the stored procedure is run as that limited user account.

How can I use TRIGGER_NESTLEVEL in this scenario without granting this user permissions on the table?

Here is complete code to reproduce. The output is:
Nest level is: 1 (running as admin)

Nest level is: (null) (running as limited user)

The output that I want would have a 1 instead of (null). Hard coding the specific OBJECT_ID is not the solution that I am looking for, since I want to use identical database scripts on separate installs of my database.




Code Block
IF OBJECT_ID(N'Hello') IS NOT NULL DROP TABLE Hello
IF DATABASE_PRINCIPAL_ID(N'TestUser') IS NOT NULL DROP USER TestUser
IF OBJECT_ID(N'HelloProcedure') IS NOT NULL DROP PROCEDURE HelloProcedure
GO

CREATE TABLE Hello
(
ID INT PRIMARY KEY IDENTITY,
Data INT NULL
)
GO

CREATE TRIGGER HelloTrigger1
ON Hello
FOR INSERT
AS
SET NOCOUNT ON
UPDATE Hello SET Data = 1234 WHERE ID IN (SELECT ID FROM inserted)
GO

CREATE TRIGGER HelloTrigger2
ON Hello
FOR UPDATE
AS
SET NOCOUNT ON
PRINT N'Nest level is: ' + ISNULL(CAST(TRIGGER_NESTLEVEL(OBJECT_ID(N'HelloTrigger1')) AS NVARCHAR(128)), N'(null)')
GO

CREATE PROCEDURE HelloProcedure
AS
SET NOCOUNT ON
INSERT INTO Hello VALUES (0)
GO

CREATE USER TestUser WITHOUT LOGIN
GO

GRANT EXECUTE ON HelloProcedure TO TestUser
GO

EXEC (N'HelloProcedure') -- Prints: Nest level is: 1
GO

EXEC (N'HelloProcedure') AS USER = N'TestUser' -- Prints: Nest level is: (null)
GO