Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database Owner is not recognised
Message
From
18/07/2000 08:28:18
 
 
To
18/07/2000 07:11:40
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
00393705
Message ID:
00393719
Views:
17
Just because a user is in the db_owners group does not mean that any objects created by the user will be owned by DBO. The user will have to explicitly specify that the object should be owned by DBO by prefixing the objects name with dbo:

CREATE TABLE dbo.foo (...)

To make the lives of your developers easier, it is recommended that all database objects be owned by DBO.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform