Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Grant user role to cre...

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

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,
Suggested answer

Stefano Demiliani 37,162 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/]
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,
Suggested answer

Stefano Demiliani 37,162 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.