[thelist] M$ SQL Server problems

Norman Beresford n.beresford at anansi.co.uk
Tue Jan 15 05:55:48 2002


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