Grant user role to create Crystal Report with Navision 2009 + SQL Server 2014

(0) Share

Report

Posted on by Community Member

Hi Everybody,

I am a newbie in Dynamic Navision. I have migrated my Dynamic Navision 2009 R2 Native DB to SQL Server DB. Now, I want to grant SQL user to have permission to create Crystal Report with SQL DB using ODBC. Could someone can show me which roles that assign to user in SQL to do the requirement?

Thanks so much,

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Community Member on at

Like (0)

Report

RE: Grant user role to create Crystal Report with Navision 2009 + SQL Server 2014

Hi Stefano,

Thank you so much,

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Grant user role to create Crystal Report with Navision 2009 + SQL Server 2014

It’s a standard SQL role:

[View:https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles]

To set:

[View:https://www.mssqltips.com/sqlservertip/3541/grant-user-access-to-all-sql-server-databases/]

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Grant user role to create Crystal Report with Navision 2009 + SQL Server 2014

Hi Stefano,

I did not see the DB_DATAREADER on my server. Could you please show me? I am running SQL Server 2014 Standard.

Regards,

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Grant user role to create Crystal Report with Navision 2009 + SQL Server 2014

I think that you need at least to create a SQL User to use from Cristal Report to read the NAV tables that will be at least DB_DATAREADER on NAV db.

Was this reply helpful? Yes No