Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database Owner is not recognised
Message
De
18/07/2000 08:28:18
 
 
À
18/07/2000 07:11:40
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Divers
Thread ID:
00393705
Message ID:
00393719
Vues:
16
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform