[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