Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
SQL Server Role for NAV Users
ta5
Member Posts: 1,164
Hello
Following up to this:
viewtopic.php?f=23&t=47512
I know, normal users don't need special roles on sql server. My question is:
What server role is needed for managing these tasks from within NAV 2009R2 on SQL Server 2008R2:
1: Creating and deleting Windows Logins
Imho user must have sysadmin. I wonder why securityadmin does not work.
2: Creating and deleting DB Logins
Imho user must have sysadmin. I wonder why securityadmin does not work.
3: Import FOBs that contain changes to tables (alter table, create table, delete table)
Imho user must have database owner (no server role, but database role).
4. Import license
Imho it depends on whether the license is set to be stored in nav db or in master db.
I'm looking for some kind of best practices.
Thanks in advance
Thomas
Following up to this:
viewtopic.php?f=23&t=47512
I know, normal users don't need special roles on sql server. My question is:
What server role is needed for managing these tasks from within NAV 2009R2 on SQL Server 2008R2:
1: Creating and deleting Windows Logins
Imho user must have sysadmin. I wonder why securityadmin does not work.
2: Creating and deleting DB Logins
Imho user must have sysadmin. I wonder why securityadmin does not work.
3: Import FOBs that contain changes to tables (alter table, create table, delete table)
Imho user must have database owner (no server role, but database role).
4. Import license
Imho it depends on whether the license is set to be stored in nav db or in master db.
I'm looking for some kind of best practices.
Thanks in advance
Thomas
0
Answers
Thanks in advance
Thomas
That was basically what I expected. Does anybody experience something else?
Thanks in advance
Thomas
Synchronization
For a user to be able to invoke the synchronization process or modifying the User table it requires membership of following Server or Database Roles:
Sysadmin server role. Alternatively both a member of the securityadmin server role and a member of the db_owner database role for this database
Altering a Database
Altering a database demands sysadmin or dbcreator server role. Alternatively a member of the db_owner or db_ddladmin database role for this database.
Delete Database sessions
Sometimes the database can run out of user licenses which means that no new users can connect to the database. To get around this problem you can throw out users that have idle or double sessions (one session/client).
The Database Sessions window lists details of all the sessions that are currently connected to the database and the time when each user logged on.
The administrator must be a member of either the sysadmin or processadmin SQL Server server rolls to be able to delete sessions
When it comes to sysadmin I think that most two people in this organisation should have this role since this gives all access to the entire server.
Edit: Forgot to copy paste required roles to delete database sessions
Have you checked the cables?
Have you released the filters?
http://www.navfreak.com
Thx a lot for your input on this.
Regards
Thomas