permissions

What is the difference between managing permissions through users and groups
or through user-defined roles?Hello,
We can create Microsoft SQL Server database roles when a group of users
needs to perform a specified set of activities in SQL Server and one of the
following is true:
* There is no applicable Microsoft Windows NT 4.0 or Windows 2000 group.
* You do not have permissions to manage Windows NT 4.0 or Windows 2000 user
accounts.
Note Avoid deep levels of nested roles because this can affect performance.
For more informaton, refer to the following topic in SQL server books
online:
"Creating User-Defined SQL Server Database Roles"
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_security_6x5x.asp
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
true and you can take advantage of Roles while have to set permissions for
numerous users e.g you have to assign permisson for sales
,marketing,packaging,acount,it and admin deprtment and all dept # 50 users
then if you will assign individualy permisions it will be headache / hecti
c
but if you create a Role on based of Department's needed privillage then you
have to just map a user account with those Role and its done . more over if
you use your Windows User Account rather SQL it will be more secure..
HTH
Regards
--
Andy Davis
Active Crypt Team
---
SQL Server Encryption Decryption Software
http://www.activecrypt.com
"docsql" wrote:

> What is the difference between managing permissions through users and grou
ps
> or through user-defined roles?
>
>