Re: Triggers on Insert, Delete

From: keene (anonymous_at_discussions.microsoft.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 14:16:31 -0800

I guess it's the problem with permissions.
FROM BOL:
Execute permissions for xp_sendmail default to members of
the db_owner fixed database role in the master database
and members of the sysadmin fixed server role, but can be
granted to other users. However, for security reasons,
you should limit permissions for this stored procedure to
members of the sysadmin fixed server role.

Does your asp user have enough permissions?

--keene
>-----Original Message-----
>Why do my asp forms stop submitting data into my SQL
Server 2000 Database when I insert a trigger to send
email on Insert or Delete? I can still add entries
manually to the database and SQL successfully send the
email out when the table is updated. Once I put the
trigger in place though my web based asp forms stop
functioning. The point was to create a employee support
database filled with web based support requests. The end
result I am looking for is to have SQL email our support
department when a support request is generated. Any
Ideas?
>
>Thanks,
>Josh
>.
>

Relevant Pages

  • Re: Permission clarification - dbo vs domainuser.dbo
    ... database is mapped to the special user inside each database called dbo. ... any object created by any member of the sysadmin fixed server role ...
    (microsoft.public.sqlserver.security)
  • Re: TRUNCATE TABLE permissions
    ... permissions of another user who did have those rights. ... > Is there any possibility to give the TRUNCATE TABLE permission and avoid> that the user that will execute this statement be table owner, members of the> sysadmin fixed server role, db_owner or member of the db_ddladmin fixed> database roles? ...
    (microsoft.public.sqlserver.server)
  • RE: truncate a table via a stored procedure
    ... TRUNCATE TABLE permissions default to the table owner, ... sysadmin fixed server role, and the db_owner and db_ddladmin fixed database ...
    (microsoft.public.sqlserver.security)
  • Re: db_denydatareader Role
    ... Is the user a member of the sysadmin fixed server role, ... via Windows group membership? ... > from any user table in the database". ...
    (microsoft.public.sqlserver.security)
  • Re: deny truncate?
    ... TRUNCATE TABLE permissions default to the table owner, ... sysadmin fixed server role, and the db_owner and db_ddladmin fixed database ...
    (microsoft.public.sqlserver.security)