Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 21st, 2010, 03:09 AM
Authorized User
 
Join Date: Nov 2008
Location: Manchester, , United Kingdom.
Posts: 21
Thanks: 3
Thanked 0 Times in 0 Posts
Send a message via MSN to MonkeyMan666
Exclamation Security

Hi,

I was wondering if someone knows a way round this. I have a database which needs to be accessed by a Windows Group with read only access. Some individuals in this group need write access.

I have added the group and then the individual logins and setup the permissions accordingly but the Windows Group seems to take precedence over the individual logins.

Does anyone know how to get around this?

Thanks

Andy
 
Old January 21st, 2010, 08:27 AM
Authorized User
 
Join Date: Nov 2008
Location: Manchester, , United Kingdom.
Posts: 21
Thanks: 3
Thanked 0 Times in 0 Posts
Send a message via MSN to MonkeyMan666
Default FIXED

I have sorted the problem, it was due to some columns in tables had the DENY permission set which took precedence over anything else.

Thanks




Similar Threads
Thread Thread Starter Forum Replies Last Post
Security Fed BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 4 December 16th, 2009 10:34 AM
Code Access Security & Role Based Security robzyc C# 6 April 11th, 2008 02:31 AM
System.Security.SecurityException: Security error coolcatjk Pro VB.NET 2002/2003 4 March 2nd, 2006 06:00 PM
security mjuliao Access 1 October 16th, 2005 12:13 AM
Security qa BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 8 June 28th, 2004 11:00 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.