RE: FN-FORUM M$ SQL Server problems

date posted 15th January 2002 14:07


Have you tried rebooting?


*gets coat*

However:

I think you need to set the permissions for *new tables* created as well as
the existing tables in the database. Therefore the new tables created by
users will inherit those users permission.

Regards

Alan



www.sensibledevelopment.com - Online Database and Game Development
www.effeffelle.com - Football Management, the Interactive SheepSkin

e: [EMAIL REMOVED]

t (land): 01273 721099
t (mobile): 07711 006551


-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of Norman Beresford
Sent: 15 January 2002 11:53
To: [EMAIL REMOVED]
Subject: FN-FORUM M$ SQL Server problems


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


============================================================

* Free listing for freelancers
* Free to advertise jobs
* Free jobs distribution service
* Free database of 5000 freelancers

Freelancers and Freelance Jobs:
http://www.freelancers.net

Forum FAQs:
http://freelancers.netrickery.com

To unsubscribe please email:
[EMAIL REMOVED]

If you have difficulties unsubscribing please email:
[EMAIL REMOVED]