Solved

How to grant user permissions within Great Plains (Backup and Restore)

Posted on 2008-10-22
4
1,588 Views
Last Modified: 2013-12-11
I have 2 users in GP that need to be able to back up and restore within Great Plains. They have proper permissions to the SQL databases but it looks like permissions must be set for the user accounts in Great Plains as well. Is this in fact the case? Where can I change these permissions? Thanks.
0
Comment
Question by:Xvand
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 1

Expert Comment

by:Dynamics_Girl
ID: 22952292
Are you using the back up utility under the file menu?
0
 
LVL 1

Author Comment

by:Xvand
ID: 22952934
Yes. We are using Back Up and Restore under the application itself. The main questions that is left is what kind of permissions are needed in order to restore from a backup? We have given the proper permissions for Backing up but restoring still fails due to lack of permissions. Thank you
0
 
LVL 1

Accepted Solution

by:
Dynamics_Girl earned 75 total points
ID: 22953735
As far as I know, you have to be logged into GP as 'SA' to use the restore screen.  There is no amount of security that will allow you to restore as a user in this screen.



0
 
LVL 18

Assisted Solution

by:Victoria Yudin
Victoria Yudin earned 50 total points
ID: 23094765
You not only have to be logged in as 'sa' or 'DYNSA' but you also have to be on the SQL server itself to do this.  
The big difference between backups and restores in SQL are that a backup is just a snapshot in time and can be performed with users in the system.  A restore can only be performed when there is no one else in the system.
Not really best practice for a production environment to have multiple users backing up and restoring.  Why is this needed?  
0

Featured Post

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question