M$ SQL Server problems

date posted 15th January 2002 13:18

Hi all

Hoping someone on the forum 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