Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .Net - P5

Tham khảo tài liệu programming microsoft sql server 2000 with microsoft visual basic .net - p5, công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả
Nội dung trích xuất từ tài liệu:
Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .Net - P5 using t he OPENROWSET funct ion because t he link ed serv er sy nt ax is m or e st raight forward, and y ou no longer hav e t o perform t he first t wo st eps. Creat e a link ed serv er for a r em ot e or het er ogeneous dat a source w it h t he sp_addlinkedserv er syst em st ored procedure. This procedure can t ak e as m any as seven argum ent s, but you can use as few as t wo argum ent s for cr eat ing a reference t o a rem ot e SQL Server source and as few as four argum ent s for a linked ser ver point ing t o an Access dat a source. Aft er cor rect ly init ializing t he linked ser ver reference wit h t he sp_addlink edserver syst em st ored pr ocedur e, inv oke sp_addlink edsrv login for m apping logins on t he curr ent SQL Ser v er 2000 inst ance t o logins for t he rem ot e or het er ogeneous dat a source. When a user runs a query on t he local ser ver against t he link ed ser ver, t he local serv er logs in t o t he link ed serv er w it h t he credent ials specified when t he sp_addlink edsrv login syst em st ored procedur e was last r un for t he link ed serv er. You can invok e t he sp_linkedserv ers syst em st ored pr ocedur e t o it em ize in a r esult set t he link ed serv ers defined on a local serv er . Se cu r it y for Vir t ua l D ir e ct or ie s Virt ual direct ories ar e necessary for Web dat a access t o SQL Serv er dat a sources via XML. Each dat abase t hat r equires Web access via XML m ust have a virt ual dir ect or y point ing t o it . As described in t he “ Virt ual Direct ory Managem ent ” sect ion of Chapt er 6, y ou m ust designat e a login for t he virt ual dir ect or y. All access t o t he dat abase is m apped t hrough t he login t hat y ou specify on t he Secur it y t ab of t he Pr opert ies dialog for a dir ect ory . Figur e 7- 1 shows t he Propert ies dialog box used for t he MyNwind v irt ual direct ory t hat ser ved as t he source for m ost of t he sam ples in Chapt er 6. Not ice t hat t he Secur it y t ab specifies I USR_CCS1 in t he User Nam e t ext box. The User Nam e t ext box cont ains t he login nam e for t he v irt ual dir ect ory . Select ing Windows as t he Account Type aut om at ically inst alls I USR_ser ver nam e as t he login. Windows 2000 Ser ver aut om at ically inst alls t he I USR_ser ver nam e user account . I I S aut om at ically uses t his Windows user account for anonym ous login. Since t he sam ples for Chapt er 6 r an fr om a serv er nam ed ccs1, t he dialog replaced serv er nam e w it h CCS1. Figu r e 7 - 1 . Use t h e Se cu r it y t a b for a vir t u a l dire ct or y t o spe cify t h e login by w h ich u se r s of t h e virt u a l dire ct or y w ill ga in a cce ss t o a SQL Se rve r.Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark. I f you decide t o allow access t o your dat abase t hr ough t he I USR_serv ernam e Windows account , y ou m ust m anually cr eat e a login for t he Windows user on your SQL Serv er inst ance. Then y ou m ust creat e a user secur it y account in t he dat abase t o w hich t he v irt ual direct ory point s. Finally y ou m ust assign perm issions t o t he I USR_serv er nam e securit y account appropriat e t o t he needs of your applicat ion. For ex am ple, if y ou want t o enable br owsers t o r ead from any row source in t he dat abase, y ou can assign t he I USR_serv er nam e user account t o t he db_dat areader fix ed dat abase role. I f you have m ore r est rict ive requir em ent s, use t he T- SQL GRANT st at em ent t o specify m or e granular perm issions, such as t he abilit y t o view j ust one t able or v iew. Mak e sure t he dat abase has perm issions for t he public role t hat don’t allow t he I USR_ser vernam e account t o access t he dat abase wit h a differ ent set of perm issions t han t he one y ou specify explicit ly for t he v irt ual dir ect or y user account . When y ou decide t o per m it updat es, insert s, and delet es t o a dat abase t hr ough a virt ual se ...