Microsoft Great Plains Security Setup - Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for mid-size company and probably good budget solutions for large corporation. Former product name was Great Plains Dynamics / eEnterprise. Both versions: old and new are Great Plains Dexterity written and Dexterity itself was planned as database and computer platform independent / transferable shell back in earlier 1990th. Currently Great Plains (version 8.0 and coming 8.5) is MS SQL Server based and the last multi-database version 7.5 (available on Pervasive SQL and Ctree/Faircom). But considering former goal ? Microsoft Great Plains has security model, which is independent from MS SQL security and works in parallel with SQL Security

User Classes and Users

? Users. Users has nothing to do with MS SQL Logins, however if you are on SQL version ? users are translated to SQL as logins and given access to all Great Plains related database: DYNAMICS and companies

? User Classes. You can automate users creation, by including new user to the class or transferring old user to different class and by doing so you have an option to reset security from the class. On the user level you can supercede class security. Class works for all the companies, while User can have different security right in each different company Objects: Windows, Reports: modified and alternate modified

? Confuse? Yes ? this is normal reaction. These all confusing terms come from the architecture of the system ? you need to know architecture highlights to recognize the terminology.

? Modified Reports. These are modified via Great Plains Reporting tool: ReportWriter ? Tools->Modify->ReportWriter and select the report you want to modify. The most popular is SOP Long Invoice form. When you are done with the modification (placing logo, etc.), you need to assign security either to the users who will be printing this report or user classes: Setup->System->Security select user id, company, product (Great Plains), type as Modified Reports, series Sales and you will see SOP Invoice Long form available in the list, mark it and you will have it available for this user.

? Modified Forms. If you purchased Great Plains Modifier ? you can modify the form, for example on Customer Maintenance screen you could place the button and attach VBA script to it ? you should have VBA/Modifier with customization site enabler license. This is the realm of VBA programmer. Security should be given to the modified form.

? Alternative Modified Forms and Reports. If you have in-house Dexterity customization working with SOP Entry screen for example ? the technology works this way ? it imports existing SOP entry screen from DYNAMICS.DIC dictionary (original Great Plains) into custom dictionary, created by Dexterity developer. Here this form is known as Alternative Form. You can go to further complexity and modify this one with Modifier and get Alternative Modified Form.

Advanced Security

? Security for specific customers, accounts, etc. ? you can protect specific object in Great Plains with this advanced security module. We'll just mention this fact and do not touch details Problems

? Central versus Local dictionary. If you have security for the user to use, say SOP Long Invoice form modified (taken from REPORTS.DIC), and you have Reports.DIC placed on local machine (check you DYNAMICS.SET file). When you give this user new computer and do not take care on transferring REPORTS.DIC from the old machine ? user will get error message ? can not open report: dictionary not found. The same is applicable to modified forms

Happy implementing! You can always appeal to us to help you with your system. Give as a call 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ( http://www.albaspectrum.com ), Microsoft Business Solutions Great Plains, Microsoft CRM, Navision, Microsoft RMS, Microsoft Business Portal customization company, serving clients in Chicago, Boston, New York, Miami, Atlanta, Houston, Dallas, Denver, Los Angeles, San Francisco, San Diego, Seattle, Minneapolis, Phoenix, Toronto, Montreal, Brazil, Mexico, UK, Australia, Canada, UK, Europe, Russia an having small offices in multiple states and internationally.

Bishop Hill taxi from Midway ..
In The News:

After a recent cyberattack affected patient record systems at Ascension, one of the largest U.S. health systems, here are a few ways you can safeguard your health records.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
Kurt "CyberGuy" Knutsson explains how to hide the apps loaded onto your Android device so others can't access them and violate your privacy.
Kurt "CyberGuy" Knutsson has a warning about a new type of malware that's targeting Apple computers for files that may contain private information.
NASA'S Dragonfly rotorcraft is scheduled for a 2028 journey to Saturn's largest moon, Titan, which is located 746 million miles from Earth.
Apple launched its first artificial intelligence product, the M4 Apple silicon chip in a new iPad Pro. Steve Jobs predicted the iPad would replace laptops.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
Artificial intelligence has made social engineering scams more sophisticated. They are scams by which criminals exploit trust for money or information.
Quadroin AUV is an underwater research robot that mimics penguins' graceful and swift swimming, descending to depths of 492 feet at speeds up to 11.5 mph.
Will fake movie trailers made with AI become real enough to take over Hollywood? Kurt “CyberGuy" Knutsson discusses more about spotting AI movie trailers and how they work.
Kurt “CyberGuy" Knutsson discusses how Triton Submarines redefines the underwater experience with the Triton 660/9 AVA, which offers panoramic views and unparalleled ocean access.
If your Facebook account has been hacked and you're having trouble logging back in, Kurt “CyberGuy" Knutsson shows you some steps to recover your account.
Kurt “CyberGuy" Knutsson reveals how the Aloha Unleashed project showcases a dual-arm robot system that autonomously performs tasks, demonstrating remarkable precision in robotics.
Air Force Secretary Frank Kendall boarded the cockpit of an F-16 controlled by artificial intelligence on Friday, before the plane entered a dogfight with a human-controlled plane.
Using a virtual private network to seach the internet has its pros and cons. It can provide more security and privacy. But users can be blocked from websites.
Dragon 12 is an underwater kite manufactured by Swedish company Minesto that promises to generate clean electricity deep under the sea.
The Federal Communications Commission slapped the nation's four biggest mobile carriers with fines totaling $200 million for unauthorized sharing of customer location information.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
The fully electric Atlas 2.0 robot was designed for real-world applications, and it is capable of lifting and maneuvering heavy, irregular objects.
Rather than spending time searching for the right buttons, here are a variety of keyboard shortcuts to make your workflow easier, faster and with less clutter.
High tech video cameras seem to find their way into the hands of Peeping Toms in hotels, dressing rooms and rental properties. Here's how to keep yourself safe.
If you consider Facebook's "People You May Know" section distracting, there's a way to temporarily remove it. There is no permanent way to eliminated it.
ChatGPT is an industry game-changer — here are a few simple prompts that can easily come in handy as personal and professional life hacks.
IPhones have several voice assist options available — like Siri and VoiceOver — that can help users search the web and read articles by voice.
The X1 exoskeleton is a motorized artificial intelligence-powered all-terrain device that straps to your waist and thighs for hiking climbing and running.

Navision Attain Database access via C/ODBC in ASP.NET Application

Navision Software was purchased by Microsoft and now it is... Read More

Microsoft CRM Customization Secrets ? Second Edition

This article is for advanced Microsoft CRM SDK C# developers.... Read More

How to Build a Basic CSS Layout

Designing without tables by using CSS layouts is fast becoming... Read More

MicroWorld Releases New Version of MailScan Ver. 4.5 - Antivirus and Content Security Software

MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More

Spyware Definitions List

The adware and spyware definitions list is very long. But... Read More

6 Easy Steps for a Smoother CD/DVD Order

It's all about turn times in the eMedia industry! The... Read More

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

Understanding Document Management

The term "document management" and "paperless office" is the subject... Read More

Adware and Spyware

What is 'adware'?Adware is basically software or scripts that are... Read More

Microsoft Great Plains in Construction & Building ? Implementation & Customization Highlights

Microsoft Great Plains could be tuned and setup to fit... Read More

Microsoft Small Business Manager Customization Options - Overview

Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

Snort for Network IDS

What is Snort?Snort is an open source network intrusion detection... Read More

Microsoft CRM for Corporate Business ? Working Offline

If your company has regional and worldwide operations, you might... Read More

Corporate ERP Selection: Microsoft Great Plains

In our opinion, traditional approach when you select ERP/MRP system... Read More

Introducing GRML

Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More

The Religion And Philosophy Of Small Internet Business

I have always had a tendency to focus on the... Read More

How To Identify, Cure and Prevent Spyware/Adware Infections

Just when you thought you were Web savvy, one more... Read More

Microsoft CRM Development

Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More

Beware of The Pirated Software E-Mail Scams!

You have gotten those E_Mails buy software at deep discounts.... Read More

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

Microsoft Great Plains is now targeting large and midsize businesses... Read More

Introduction To ISDN, Part III: PAP

Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More

Is Software Tester a Most Infamous Person in a Software Project Team?

The fact that a software tester is a most infamous... Read More

Crystal Reports - Microsoft SQL Server

Microsoft SQL Server is the leader for inexpensive and middle... Read More

Microsoft Great Plains Upgrade ? Version 8.0 Overview for IT Director/Controller

If you have Microsoft Great Plains as main accounting and... Read More

How a Bug Challenges to a Software Professional

It is really interesting that a bug can create problem... Read More

car service to O'Hare Volo ..