Solved

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

Posted on 2008-10-22
4
1,581 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
  • 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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Suggested Solutions

If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

679 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