Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Record Permissions
Message
De
28/06/1999 12:49:37
 
 
À
21/06/1999 16:51:34
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00232196
Message ID:
00234825
Vues:
23
SQL Server does not natively support permissions at the row level. What about a view that references the USER_NAME() function and the WITH CHECK option?

CREATE VIEW OnlyMyData
AS
SELECT *
FROM table
WHERE owner_column = USER_NAME()
WITH CHECK OPTION

Permissions should not be an issue if the view and table are owned by the same user.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform