Q:

What Access Rights am I Missing on my Stored Procedure

I'm trying to run a stored procedure from my website that disables a trigger. Here is the code for the trigger:
CREATE PROCEDURE [dbo].[DisableMyTrigger]
AS
BEGIN
    alter table dbo.TableName DISABLE TRIGGER TriggerName
END

I've also set the permissions on the stored procedure with:
Grant Exec on dbo.DisableMyTrigger To DBAccountName

DBAccountName is and has been able to run other stored procedures as well as dynamic SQL statements without issue. 
Here is the code from my CFM page:
<cfstoredproc datasource="myDatasource" procedure="DisableMyTrigger" />

And here is the error I'm getting:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][SQL Native Client][SQL Server]Cannot find the object "TableName" because it does not exist or you do not have permissions.

A:

Does DBAccountName have permissions to TableName? These can be granted or revoked separately from the overall schema (dbo).
I'm not a dba, but is DBAccountName allowed to execute DDL statements? (so it can do things like disable triggers programmatically)

