Re: Roles
From: Donna Lambert [MS] (dlambert@online.microsoft.com)
Date: 08/08/02
- Next message: Donna Lambert [MS]: "Re: Thank you very much...again"
- Previous message: Massimiliano: "Can I Hide system sp,view,tables to public role?"
- In reply to: Sue Hoegemeier: "Re: Roles"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: dlambert@online.microsoft.com (Donna Lambert [MS]) Date: Thu, 08 Aug 2002 13:43:17 GMT
"Rideout,"
Sue is absolutely correct here. Using the analogy of groups in Windows can
help you to understand how to use roles. There are several topics in Books
Online which covers roles, and you might want to read through them to get
more details.
Some good topics in BOL:
"Roles"
"Adding a member to a SQL Server database Role"
"Security Architecture" (good diagram that shows a parallel between roles
and NT groups)
"Logins, Users, Roles, and Groups" (and bears, oh my!)
Seriously, those should give you a solid foundation on roles in SQL!
Thanks Sue for your quick and accurate input!
Donna Lambert
Microsoft SQL Server Support
Disclaimer:
This posting is provided “AS IS” with no warranties, and confers no rights.
Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Recent viruses on the Internet underscore the threat to all computer users
and highlight challenges facing the entire industry in providing security
that everyone needs to conduct business. I encourage you to sign up to
receive automatic notification of Microsoft Security Bulletins by visiting
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/
bulletin/notify.asp. For more information on security, our Strategic
Technology Protection Program and to order your FREE Security Tool Kit,
please visit http://www.microsoft.com/security. We will be happy to answer
any questions or provide assistance with your security needs.
--------------------
| From: Sue Hoegemeier <Sue_H@nomail.please>
| Subject: Re: Roles
| Date: Mon, 22 Jul 2002 12:22:29 -0600
| Message-ID: <o5joju8puf9af83c61ol0gupmrt84tttvf@4ax.com>
| References: <1939101c231ab$8cb647c0$37ef2ecf@TKMSFTNGXA13>
| X-Newsreader: Forte Agent 1.91/32.564
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Newsgroups: microsoft.public.sqlserver.security
| NNTP-Posting-Host: 67.234.191.211
| Lines: 1
| Path: cpmsftngxa07!cpmsftngxa06!tkmsftngp01!tkmsftngp13
| Xref: cpmsftngxa07 microsoft.public.sqlserver.security:7127
| X-Tomcat-NG: microsoft.public.sqlserver.security
|
| They are similar in that you can use them as a security
| management tool. You can add users with the same security
| requirements to roles and then set the permissions for the
| roles (instead of setting the same permissions on all the
| individual users). Users will inherit permissions based on
| their role membership.
|
| -Sue
|
| On Mon, 22 Jul 2002 11:13:58 -0700, "Rideout"
| <mrideout@instlab.com> wrote:
|
| >Is roles in SQL Server 2000 the samething as the
| >usergroups in Windows 2000?
| >
| >THANKS IN ADVANCE,
| >Rideout.
|
|
- Next message: Donna Lambert [MS]: "Re: Thank you very much...again"
- Previous message: Massimiliano: "Can I Hide system sp,view,tables to public role?"
- In reply to: Sue Hoegemeier: "Re: Roles"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
