Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I get all the registered users in a MS SQL Serve
Message
 
 
À
03/07/2002 20:44:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00675178
Message ID:
00675191
Vues:
10
This message has been marked as the solution to the initial question of the thread.
You can use sp_helpuser system stored procedure.
? SqlExec(lnConn, [EXEC sp_helpuser])
See BOL for details.

>Hi friends!
>
>I'm developing an application which has a lot of users and security access is a must. I have to register new users in SQL Server so the user can access it but I have to register also in the application because the users have several more attributes that are controled by the app. Is there a way to get all the users and save them in a .DBF table? TIA.
>
>Luis
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform