Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: Database Trigger
Topic Summary: Database Trigger for Non-Owner
Created On: 11/28/2017 05:30 AM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 11/28/2017 05:30 AM
User is offline View Users Profile Print this message

Author Icon
ScottDerousse
Student (5-19 posts)

Posts: 11
Joined: 04/25/2005

Using AM 10.5.0.56 and Microsoft SQL Server 2012 - 11.0.5343.0 (X64), I can only create a working database trigger if the SQL user I put in the trigger has either control permissions on the database or is the owner (implying control) of the database. What are the minimum permissions required for a user to be able to be used for triggering? I tried a user with all explicit permissions on the database except control, and it still can't create the procs, service or queues needed, even if I "GRANT SUBSCRIBE QUERY NOTIFICATIONS TO test_trigger" (where "test_trigger" is the database principal). Is it possible to use a limited permissions user to trigger a task? If so, how?

Thanks,
Scott

 Category Survey
 11/28/2017 05:32 AM
User is offline View Users Profile Print this message

Author Icon
ScottDerousse
Student (5-19 posts)

Posts: 11
Joined: 04/25/2005

BTW - when I tried giving everything except control, I get the following in the event log (note the user name was "test_trigger", not "owner":

Database failed : Cannot find the user 'owner', because it does not exist or you do not have permission.
Cannot find the queue 'SqlQueryNotificationService-219b3b7c-a4ab-4afd-97c6-a2fbeeed385b', because it does not exist or you do not have permission.
Invalid object name 'SqlQueryNotificationService-219b3b7c-a4ab-4afd-97c6-a2fbeeed385b'.


 Category Survey
 11/29/2017 01:55 PM
User is offline View Users Profile Print this message

Author Icon
Ricardo Castaneda
HelpSystems

Posts: 3424
Joined: 01/11/2008

Hello,

Would it be possible to set-up a GoToAssist session where we can take a closer look at this issue? If this is possible please send an email over to AutoMate.Support@helpsystems.com with a list of your availability.

Note: Please reference this forum thread in your email.


 Category Survey


-------------------------

Ricardo Castaneda | Principal Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700
 11/29/2017 02:41 PM
User is offline View Users Profile Print this message

Author Icon
Hamid Noorbakhsh
HelpSystems

Posts: 454
Joined: 07/29/2008

Just an FYI http://forums.networkautomatio...atid=73&threadid=13388 in case you need more for your setup.

The DB has to be able to send messages:

ALTER DATABASE yourDatabaseNameHere SET ENABLE_BROKER;

Also include schema name with table name


 Category Survey
AutoMate 10 version:
Windows version:


-------------------------
Thank you for choosing AutoMate

Hamid Noorbakhsh | Senior Software Engineer
AutoMate | A Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700

Edited: 11/29/2017 at 02:48 PM by Hamid Noorbakhsh
 12/20/2017 06:33 AM
User is offline View Users Profile Print this message

Author Icon
ScottDerousse
Student (5-19 posts)

Posts: 11
Joined: 04/25/2005

Sorry for the delay getting back (tis the season!) I sent the email with times for today & tomorrow.

Thanks,
Scott

 Category Survey
Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 5551 on 01/08/2018 at 11:11 AM.
There are currently 2206 guests browsing this forum, which makes a total of 2206 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2020 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog