Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics GP (Great Plains) > GP - Installation and Administration
  New Posts New Posts RSS Feed - security
  FAQ FAQ  Forum Search   Register Register  Login Login


security

 Post Reply Post Reply
Author
Message
amossql View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: February 12 2007
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote amossql Quote  Post ReplyReply Direct Link To This Post Topic: security
    Posted: September 17 2007 at 1:46pm
I need to give a user right to create other users and grant access to companies.  I do not want to give this user SA rights to SQL
Back to Top
Sponsored Links


Back to Top
amossql View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: February 12 2007
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote amossql Quote  Post ReplyReply Direct Link To This Post Posted: September 18 2007 at 7:30am
Do any one know what role i need to give an admin user in order to create user and assign this user a company. I do not want this user to have sysadmin role. Exclamation
Back to Top
LeslieVail View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: August 05 2007
Status: Offline
Points: 45
Post Options Post Options   Thanks (0) Thanks(0)   Quote LeslieVail Quote  Post ReplyReply Direct Link To This Post Posted: October 13 2007 at 4:40pm

The user needs to be part of the dbcreator and securityadmin roles.

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com