User groups (1 Viewer)

aman

Registered User.
Local time
Today, 02:44
Joined
Oct 16, 2008
Messages
1,250
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
 

kevlray

Registered User.
Local time
Today, 02:44
Joined
Apr 5, 2010
Messages
1,046
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).
 

aman

Registered User.
Local time
Today, 02:44
Joined
Oct 16, 2008
Messages
1,250
Hi RX, I can't find the link to Data security in sql server . Can you please send me the powerpoint presentation?
 

WayneRyan

AWF VIP
Local time
Today, 09:44
Joined
Nov 19, 2002
Messages
7,122

Users who are viewing this thread

Top Bottom