Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-01-2018, 11:54 PM   #1
aman
Newly Registered User
 
Join Date: Oct 2008
Posts: 1,160
Thanks: 51
Thanked 1 Time in 1 Post
aman is an unknown quantity at this point
User groups

Hi Guys

What are user groups in sql server? why do we need to create them? Can we create by ourselves or this needs to be done by helpdesk. (not developers).

Does it relate to database security ? Can anyone please explain?

Thanks

aman is offline   Reply With Quote
Old 05-02-2018, 06:28 AM   #2
kevlray
Newly Registered User
 
Join Date: Apr 2010
Location: Central California
Posts: 569
Thanks: 9
Thanked 50 Times in 48 Posts
kevlray will become famous soon enough
Re: User groups

I can provide some basic information. By defining a user group you can set security for that group to only have particular rights to a database/table (in newer versions of MS-SQL even more control). Of course you would have to particular rights to the database to create user groups and control their security (I do not recall what those rights are).
kevlray is offline   Reply With Quote
Old 05-14-2018, 04:34 AM   #3
Rx_
Nothing In Moderation
 
Rx_'s Avatar
 
Join Date: Oct 2009
Location: Denver, Colorado
Posts: 2,768
Thanks: 623
Thanked 331 Times in 303 Posts
Rx_ has a spectacular aura about Rx_ has a spectacular aura about Rx_ has a spectacular aura about
Re: User groups

Just posted a link to a free powerpoint presentation on this subject.
https://www.access-programmers.co.uk...splay.php?f=89

Rx_ is offline   Reply With Quote
Old 05-25-2018, 12:45 AM   #4
aman
Newly Registered User
 
Join Date: Oct 2008
Posts: 1,160
Thanks: 51
Thanked 1 Time in 1 Post
aman is an unknown quantity at this point
Re: User groups

Hi RX, I can't find the link to Data security in sql server . Can you please send me the powerpoint presentation?

aman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking to get involved with Access User groups MSAccessRookie Microsoft Access User Groups 0 08-09-2013 10:19 AM
Security With User Groups. (Understanding work groups) ConfusedA General 10 07-23-2009 05:35 AM
Security and user groups CoachPhil General 0 07-07-2009 06:32 PM
Security - User Groups Oscar General 1 05-20-2003 03:34 AM
Identifying user groups danikuper Forms 6 02-19-2003 06:48 AM




All times are GMT -8. The time now is 09:14 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World