AX 2009 | ErpCoder

Using SQL DDL Triggers to restore read Permissions programatically after Dynamics AX 2009 Synchronization

26. September 2019 Leave a comment

Recently, a customer using Dynamics AX 2009 implemeted a web service that access a view directly in SQL Server. Therefore they created a new SQL user login and gave the user read permissions on the view.

However, when synchronizing the data dictionary in Dynamics AX 2009, the views are droped and recreated and the permission on the object is lost. Therfore the webservice call fails.

One way to address this issue from a SQL perspective is to create a DDL trigger that sets the permissions on the view programmatically. Here is a small SQL script that sets read permissions for the user view_user on the the DIRPARTYVIEW after the view has been created again.

CREATE TRIGGER [VIEW_PERMISSION] 
ON DATABASE 
    FOR CREATE_VIEW
AS 
BEGIN
    DECLARE @name SYSNAME
    SELECT  @name = EVENTDATA().value('(/EVENT_INSTANCE/ObjectName)[1]','SYSNAME')

    if @name = 'DIRPARTYVIEW' begin
        GRANT SELECT ON [dbo].[DIRPARTYVIEW] TO [view_user]
    end
END
GO

ENABLE TRIGGER [VIEW_PERMISSION] ON DATABASE
GO

Filed under Admin, Development, Dynamics AX Tagged with AX 2009, SQL Server

Color Rows in Enterprise Portal AxGridView

3. August 2011 Leave a comment

Create a new display method webBackgroundColor at InventTable

public display Color webBackgroundColor()
{;
    switch(this.ItemType)
    {
        case ItemType::BOM:     return "Red";
        case ItemType::Item:    return "Green";
        case ItemType::Service: return "Blue";
        default: return "White";
    }
}
Create a new Dataset and add InventTable as DataSource
Create or open a new Dynamcis Ax web project in Visual Studio
Create or open an AxWebUserControl and add an AxDataSource using InventTable data set from AX
Add an AxGridView and link it with the AxDataSource
Add webBackroungColor**, ItemId and ItemName to the grid
Select the AxGridView, change to events and modify the RowDataBound event

protected void AxGridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    string axColor = e.Row.Cells[0].Text.ToLower();

    if(axColor.Equals("red"))
        e.Row.BackColor = System.Drawing.Color.Red;
    else if(axColor.Equals("green"))
        e.Row.BackColor = System.Drawing.Color.Green;
    else if(axColor.Equals("blue"))
        e.Row.BackColor = System.Drawing.Color.Blue;
}
Load the user control in an enterprise portal site

Use an Extended Datatype (Color instead of str) for the display method, otherwise you may experience strange behaviour in your ASP.NET application.

Filed under Dynamics AX, Enterprise Portal Tagged with AX 2009, AxGridView, Enterprise Portal

Book Review: DAX 2009 Administration

15. May 2011 1 Comment

I’ve bought and read the book Dynamics AX 2009 Administration by Marco Carvallo. It’s a book for Dynamics AX admins working with AX 2009. However, I’ve found some positive and negative points.

The book puts administration in the context of Dynamics Sure Step
It contains backup and performance optimization
It covers the basic real life topics and is therefor usefull for daily work
It spares the more rare topics like project server integration
It leaves the gap between EP installation and development / security configuration

Filed under Admin Tagged with Admin, AX 2009