Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
OK, I can create login in SS,
But how to add users to databases and roles?
"sp_grantdbaccess cannot be executed from within a user-defined transaction",
also sp_addrolemember.
Stored proc is user-defined transaction.
I have central server and local server(s).
Accounts are managed from special maintainance app which runs in central location. I need to "replicate" creation, deletion and resseting of psswd to local location.
Vytautas
>Are you asking for a way to manage users using stored procedures? If so, yes. Take a look at sp_addlogin and sp_grantlogin. You might also want to Administering SQL Server | Managing Security | Creating Security Accounts.
>
>-Mike
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement