slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Data & Imports Forums - T-SQL & Queries
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to T-SQL & Queries | New Thread

View: Search:

Author

Thread: userid in trigger(pl\sql)

Georgiy.Celovansky
Posts: 13

userid in trigger(pl\sql) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Sep 10 7:55 AM

How can I get slx userid in script? When I am using standard oracle variable it returns DB user, but I need slx user

[Reply][Quote]

Phil Parkin
Posts: 819

Re: userid in trigger(pl\sql) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Sep 10 10:35 AM

There is no direct way of doing this, because all updates are done by a single database user (sysdba on SQL Server - I've never used Oracle).

However, if this is an INSERT or UPDATE trigger, the record which is being acted on will contain a field called MODIFIEDBY - that is the SLX userID you're looking for.

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: userid in trigger(pl\sql) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Sep 10 12:11 PM

If you configure SQL server to not allow TCPIP connections, then you may be able to get the Domain ID of the user making the change (good for Network and Remote users, but not good if you are running SLX Web, as then the only Credentials you would get is the Service Account used to run the application).

So, the best solution as mentioned by Phil is to get it from the MODIFYUSER field (this is the correct Field name)

As long as the Statements are being ran through the SLX Provider, it will ensure that there is always a MODIFYUSER on it, so you could capture it from there as it will be part of the DataSet.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: userid in trigger(pl\sql) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Sep 10 12:25 PM

Quote:

Originally posted by Raul A. Chavez

So, the best solution as mentioned by Phil is to get it from the MODIFYUSER field (this is the correct Field name)

--

Oops - thanks Raul, I knew I should have double-checked.

[Reply][Quote]

Georgiy.Celovansky
Posts: 13

Re: userid in trigger(pl\sql) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Sep 10 1:18 AM

Thx, I've already done it with MODIFYUSER.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 4:47:03 AM