[thelist] M$ SQL Server problems

[Damian Maclennan]

Hi

When you say "all pre-defined" roles, do you mean db_denydatareader and 
db_denydatawriter as well ?

They _may_ take precedencce over some of the others.

Damian


>From: "Norman Beresford" <n.beresford at anansi.co.uk>
>Reply-To: thelist at lists.evolt.org
>To: <thelist at lists.evolt.org>
>Subject: [thelist] M$ SQL Server problems
>Date: Tue, 15 Jan 2002 11:57:26 -0000
>
>Hi all
>
>Hoping someone on the list can help me with a problem I've got with a SQL
>Server machine atm.
>
>The problem I've got is that an assigned user can create tables, but then
>has no permissions on those tables.  The user is a member of all the
>pre-defined database roles, including db_owner.  I've tried setting the
>permissions on the tables whilst logged in as administrator on the machine,
>but those permission changes aren't "sticking" once applied.
>
>Has anyone got any ideas?
>
>Norman
>
>
>--
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !




_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com