http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/3236.aspxThu, 08 Nov 2007 17:43:05 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:3236crestinul0http://sqlserver.ro/forums/thread/3236.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=3236<P>Merci</P> <P>Stiam de tehnica asta ce nu am reusit eu sa fac folosind certificate e sa securizez(autentificare plus eventual cryptare conexiune)&nbsp;o conexiune tcp/ip intre doua enpointuri sql ,de ex service broker enpoints,de asta am pus intrebarea asta .</P>http://sqlserver.ro/forums/thread/3228.aspxThu, 08 Nov 2007 13:16:25 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:3228Diana0http://sqlserver.ro/forums/thread/3228.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=3228Nu,"CREATE USER...FROM CERTIFICATE" nu inseamna ca owner-ul certificatului&nbsp; va fi userul&nbsp; creat&nbsp; (sper ca te-am inteles bine...<img src="http://sqlserver.ro/emoticons/emotion-1.gif" alt="Smile" />). Este un "work around" folosit pentru aasigna o "semnatura" procedurilor storate. Vezi Books Online ---&gt; <span id="nsrTitle">Signing Stored Procedures with a Certificate si un alt exemplu la http://blogs.msdn.com/remusrusanu/archive/2006/03/07/545508.aspx.<br> </span>http://sqlserver.ro/forums/thread/3221.aspxThu, 08 Nov 2007 08:50:46 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:3221crestinul0http://sqlserver.ro/forums/thread/3221.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=3221<P>Am urmatoarea nedumerire privind certificate in sql server 2005</P> <P>Pot face ca un un user sa devina ownerul unui certifact astfel:</P> <P>Create certificate test authorization gigel</P> <P>Deci in aces caz gigel este ownerul ceriticatului test</P> <P>Insa am si urmatoarea sintaxa acreate user/login</P> <P>Create login/user from certificate test</P> <P>Intrebarea mea e cele doua sunt echivalente adica in ambele cazuri userul/loginul gigel e ownerul certificatului test?</P> <P>Multumesc</P> <P>&nbsp;</P>