basshead22
Registered User.
- Local time
- Today, 02:01
- Joined
- Dec 17, 2013
- Messages
- 52
Hello All,
Few Questions!!
I have a front end access database that has linked tables that reside in a SQL Server Database.
I have about 300 + users using the database at any given time.
I want to grant them access to the tables using an Active Directory group which they all reside in at the moment.
I know how to create a login for a group that is not the issue ... the issue or question is do i create the login at the database security level? or at the SQL Server Security level?
Issue/Question #2 What server role or roles can be used without having to give them full access (sysadmin, SA,)etc.....
Any help or guidance is much appreciated!!
Few Questions!!
I have a front end access database that has linked tables that reside in a SQL Server Database.
I have about 300 + users using the database at any given time.
I want to grant them access to the tables using an Active Directory group which they all reside in at the moment.
I know how to create a login for a group that is not the issue ... the issue or question is do i create the login at the database security level? or at the SQL Server Security level?
Issue/Question #2 What server role or roles can be used without having to give them full access (sysadmin, SA,)etc.....
Any help or guidance is much appreciated!!