RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

Get "menu user access" in SQL

"User Menu Level" table you could query :  SELECT "ID",CASE WHEN "ID Type" = 1 THEN 'Database' WHEN "ID Type" = 2 THEN 'Windows' END AS "ID Type",CASE WHEN "Level" = 10 THEN 'User Restrictions' WHEN "Level" = 20 THEN 'User Changes' END AS "Level","Modified","Object"FROM "User Menu Level" the "Object" is in binary format. 
Leggi tutto il post...
Categoria: Dynamics NAV ALL
venerdì, 21 mag 2010 Ore. 13.00

Scrivi un commento


Non è possibile inviare commenti a questo Blog

Commenti

Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003