Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alter Login/Create Login
Message
De
03/05/2006 10:59:35
Jon Neale
Bond International Software
Wootton Bassett, Royaume Uni
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01118735
Message ID:
01118794
Vues:
24
Soemthing like this

Declare @SomeUser Varchar(128)
set @SomeUser = 'FredtheBed'

EXEC sp_addlogin @SomeUser, 'food', 'isc_clients'


>Is there a way to accomplish something like:
>
>
>CREATE PROCEDURE Secure.dbo.AddUser
>@SomeUser Varchar(128)
>
>
>CREATE LOGIN @SomeUser with password = '93846756', default_database='Secure'
>create user @SomeUser
>
>
>I have found a post that suggests a building string and using EXEC. Is there some other way? If not, I'll deal.
>
>TIA
>Richard
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform