Navision - SQL Server - Stored Procedures - sp_setapprole

cdennis

I have Navision many users and many Companies. I need to allow some of my Navision users to continue their access to the data via the Navision application but at the same time I need to allow for FAR MORE RESTRICTED access to the SQL Database when ever those same NT Authenticated Navision users access the database direct through some other tools (such as Microsoft Access)

a. Can you execute Stored Procedures from within Attain/Navision
b. Can/has anyone accessed Navision after invoking sp_setapprole stored procedure?

jemmy

Hi CDennis,

a. Can you execute Stored Procedures from within Attain/Navision
b. Can/has anyone accessed Navision after invoking sp_setapprole stored procedure?

Last week, I have a same question like you.

a. No, You can't execute SP within Naision standard.
b. It can't either.

I think you should use ADO within Visual Basic to access stored procedure in Navision MS.SQL DB. I still haven't try it too... :oops:

Hope this helps,

Jemmy

cdennis

Thanks