h1

Crearea unui login in mssql (clauza CREATE LOGIN). Clauza CREATE CREDENTIAL

March 8, 2010

Pasul1: Click pe tabul Security din Object Explorer

Pasul2: Click pe tabul Logins (se observa ca am creat deja un login mihaispr ,iar sa este login-ul implicit pt.system administrator)

Pasul3: Click dreapta pe Logins si alegem New Login

Pasul4: Se alege optiunea sql server authentification (pt.a ne autentifica in sql server doar cu user si parola), windows authentification permite intrarea directa in sql server: (se completeaza doar login name, password si confirm password)

Din cod (clauza CREATE LOGIN):

Se poate crea si din cod:

Exemplul1:

Exemplul2:

Exemplul3:

Exemplul4:

Crearea unui user (clauza CREATE USER):

Exemplul1:

Exemplul2:

ALTER USER SI DROP USER:

ALTER LOGIN

DROP LOGIN:

Clauza CREATE CREDENTIAL:

A credential is a record that contains the authentication information that is required to connect to a resource outside SQL Server. Most credentials include a Windows user and password.

http://msdn.microsoft.com/en-us/library/ms189522.aspx

Exemplu create credential (in security credentials):

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: