hvordan opretter man brugere??

sp_addlogin [ @loginame = ] 'login'
    [ , [ @passwd = ] 'password' ]
    [ , [ @defdb = ] 'database' ]
    [ , [ @deflanguage = ] 'language' ]
    [ , [ @sid = ] sid ]
    [ , [ @encryptopt = ] 'encryption_option' ]

Arguments
[@loginame =] 'login'

Is the name of the login. login is sysname, with no default.

[@passwd =] 'password'

Is the login password. password is sysname, with a default of NULL. After sp_addlogin has been executed, the password is encrypted and stored in the system tables.



Security Note  Do not use a blank password. Use a strong password. For more information, see Security Rules.


[@defdb =] 'database'

Is the default database of the login (the database the login is connected to after logging in). database is sysname, with a default of master.

[@deflanguage =] 'language'

Is the default language assigned when a user logs on to SQL Server. language is sysname, with a default of NULL. If language is not specified, language is set to the server's current default language (defined by the sp_configure configuration variable default language). Changing the server's default language does not change the default language for existing logins. language remains the same as the default language used when the login was added.

[@sid =] sid

Is the security identification number (SID). sid is varbinary(16), with a default of NULL. If sid is NULL, the system generates a SID for the new login.  Despite the use of a varbinary data type, values other than NULL must be exactly 16 bytes in length, and must not already exist. SID is useful, for example, when you are scripting or moving SQL Server logins from one server to another and you want the logins to have the same SID between servers.

[@encryptopt =] 'encryption_option'

Specifies whether the password is encrypted when stored in the system tables. encryption_option is varchar(20), and can be one of these values.

Value Description
NULL The password is encrypted. This is the default.
skip_encryption The password is already encrypted. SQL Server should store the value without re-encrypting it.
skip_encryption_old The supplied password was encrypted by a previous version of SQL Server.  SQL Server should store the value without re-encrypting it. This option is provided for upgrade purposes only.


Return Code Values
0 (success) or 1 (failure)

Derefter for at give adgang til databaser:

sp_grantdbaccess
Adds a security account in the current database for a Microsoft® SQL Server™ login or Microsoft Windows NT® user or group, and enables it to be granted permissions to perform activities in the database.

Syntax
sp_grantdbaccess [@loginame =] 'login'
    [,[@name_in_db =] 'name_in_db' [OUTPUT]]

Arguments
[@loginame =] 'login'

Is the name of the login for the new security account in the current database. Windows NT groups and users must be qualified with a Windows NT domain name in the form Domain\User, for example LONDON\Joeb. The login cannot already be aliased to an account in the database. login is sysname, with no default.

[@name_in_db =] 'name_in_db' [OUTPUT]

Is the name for the account in the database. name_in_db is an OUTPUT variable with a data type of sysname, and a default of NULL. If not specified, login is used. If specified as an OUTPUT variable with a value of NULL, @name_in_db is set to login. name_in_db must not already exist in the current database.

Return Code Values
0 (success) or 1 (failure)

kan man sætte det ind i query analyser???

Ikke ovenstående.

Det er klippet fra books online med syntaxen for de to stored procedures, du skal bruge for at oprette login og give dette login adgang til en database.

Procedurerne kan kaldes fra Query Analyzer.

okai.. ikke lige det jeg ledte efter men okai..
jeg skal bare have fundet ud af hvordan jeg opretter en bruger via query analyser. eller om man overhovedet kan gøre det.

Det kan lade sig gøre.

sp_addlogin opretter et SQL Server login (SQL Authentication).

sp_addlogin @loginname = 'NytLogin', @password = 'NytPassword'

Herefter har du et login på SQL Serveren med navn NytLogin.


For at give adgang til en database skal du efterfølgende køre sp_grantdbaccess mod databasen:

sp_grantdbaccess @loginname = 'NytLogin', @name_in_db = 'LoginIDB'

parameteren @name_in_db kan udelades - så anvendes @loginname i stedet.

Hvis din SQL Server kører Windows Authentication, skal du i stedet bruge

sp_grantlogin

sp_grantlogin @loginname='MitDomæne\MitLogin'

Efterfølgende skal sp_grantdbaccess køres:

sp_grantdbaccess @loginname='MitDomæne\MitLogin', @name_in_db = 'MitLogin'

har prøvet det du har skrevet, men det kan godt være det er mig der ikke kan finde ud af det for det virker ikke.

Skal du bruge SQL Server login eller Windows Authentication?

Hvad hedder din bruger?

Hvad hedder din database?

Hvis du giver mig dem, så udfylder jeg statements til dig således, at du selv skal fylde password i.

Har du slået til så man kun _KAN_ bruge Windows logins og ikke sql logins?

Hvis du har adgang til Enterprise manager, så er det lidt nemmere !

hvis han har Enterprise manageren, kan det ikke blive meget nemmere, det vil jeg give arne_v ret i, men tror ikke hun/han har det.

og jeg ville nok også læse om application roles. Det er en god måde at få lavet rettighederne på, så det kun er bestemte brugere, af bestemte applicationer, der kan lave noget på sql serveren.

jeg har fundet ud af det..
har fået lidt hjælp andet steds fra.
men tak for tiden og hjælpen.

Hvad var svaret?