SQL&nbsp;ServerûȨ|hyenpkjvlg||hyenpkjvlg|2005-03-02.11:11|hyenpkjvlg|13|hyenpkjvlg|SQL&nbsp;ServerûȨ&nbsp;<br>SybaseеûΪ֣SQLû¼ʺţݿû&nbsp;װSQLϵͳԶһSQLûsaΪգϵͳԱϵͳвȨûϵͳԱ&nbsp;<br>SQL&nbsp;ServerûϵͳԱûݿߣӦݿݿûDBOһûϵͳԱϵͳвȨûݿ߶ݿȫȨһûԸݿֻбȨĲȨޡ&nbsp;<br>ݿûһɷΪû飬һݿڽ󼴱һûpublic&nbsp;<br>1SQLû¼ʺţ&nbsp;<br>ΪһûΪʹSQL&nbsp;ServerSQL&nbsp;ServerһSQLû¼ʺţʺϵͳԱͨsp_addloginӵġ&nbsp;<br>sp_addlogin&nbsp;¼ԣȫ&nbsp;<br>ûzhang,&nbsp;Ϊzhangling(λ)ȫΪZhang&nbsp;ling&nbsp;<br>1&gt;&nbsp;sp_addlogin&nbsp;zhang,zhangling,null,null,Zhang&nbsp;ling&nbsp;<br>2&gt;&nbsp;go&nbsp;<br>3&gt;&nbsp;select&nbsp;*&nbsp;from&nbsp;syslogins&nbsp;<br>4&gt;&nbsp;go&nbsp;<br>2ݿû&nbsp;<br>ͬΪʹSQL&nbsp;Serverϵݿ⣬ݿһûûݿͨsp_adduserӵġݿûغûʻһڲͬݿûԲͬûͬSQL&nbsp;ServerʻͬSQL&nbsp;Serverʻͬݿ&nbsp;<br>sp_adduser&nbsp;¼&nbsp;<br>¼ΪûSQL¼ΪûݿеûΪûݿû顣&nbsp;<br>ûzhangΪtele114ûΪzhang1,ûchina&nbsp;<br>1&gt;sp_addgroup&nbsp;china&nbsp;<br>2&gt;go&nbsp;<br>1&gt;sp_adduser&nbsp;zhang,zhang1,china&nbsp;<br>2&gt;go&nbsp;<br>1&gt;&nbsp;sp_helpuser&nbsp;<br>2&gt;&nbsp;go&nbsp;<br>*ɾzhang1,ûchina,¼zhang&nbsp;<br>1&gt;&nbsp;use&nbsp;tele114&nbsp;<br>2&gt;&nbsp;go&nbsp;<br>3&gt;&nbsp;sp_dropuser&nbsp;zhang1&nbsp;<br>4&gt;&nbsp;go&nbsp;<br>5&gt;&nbsp;sp_helpuser&nbsp;<br>6&gt;&nbsp;go&nbsp;<br>1&gt;sp_dropgroup&nbsp;china&nbsp;<br>2&gt;go&nbsp;<br>1&gt;&nbsp;sp_helpgroup&nbsp;<br>2&gt;&nbsp;go&nbsp;<br>3&gt;&nbsp;use&nbsp;master&nbsp;<br>4&gt;&nbsp;go&nbsp;<br>5&gt;&nbsp;sp_droplogin&nbsp;zhang&nbsp;<br>6&gt;&nbsp;go&nbsp;<br>7&gt;&nbsp;select&nbsp;*&nbsp;from&nbsp;syslogins&nbsp;<br>8&gt;&nbsp;go&nbsp;<br>3ݿȨ&nbsp;<br>grant&nbsp;&nbsp;to&nbsp;û&nbsp;<br>A.&nbsp;ϵͳԱûCREATE&nbsp;DATABASEȨޣʹûԳΪݿߡ&nbsp;<br>B.&nbsp;ݿӵеݿУûȨУ&nbsp;<br>l&nbsp;CREATE&nbsp;TABLE&nbsp;-------------------&nbsp;&nbsp;<br>lCREATE&nbsp;DEFAULT&nbsp;------------------&nbsp;ȱʡ&nbsp;<br>lCREATE&nbsp;RULE&nbsp;-------------------&nbsp;&nbsp;<br>lCREATE&nbsp;PROCedure&nbsp;------------------&nbsp;洢&nbsp;<br>lCREATE&nbsp;VIEW&nbsp;-------------------&nbsp;ͼ&nbsp;<br>lDUMP&nbsp;DATABASE&nbsp;-------------------&nbsp;ݿ&nbsp;<br>lDUMP&nbsp;TRANsaction&nbsp;------------------&nbsp;־&nbsp;<br>C.&nbsp;ݿ߿ûĲȨУ&nbsp;<br>l&nbsp;SELECT&nbsp;<br>l&nbsp;UPDATE&nbsp;<br>l&nbsp;INSERT&nbsp;<br>l&nbsp;EXECute&nbsp;<br>l&nbsp;DELETE&nbsp;<br>l&nbsp;REFERENCE&nbsp;<br>zhang1ݿtele114Ͻͼ洢;Աstudentsselect,referenceȨname,nativeֶupdateȨ&nbsp;<br>1&gt;&nbsp;use&nbsp;tele114&nbsp;<br>2&gt;&nbsp;go&nbsp;<br>3&gt;&nbsp;grant&nbsp;creat&nbsp;table,create&nbsp;procedure&nbsp;,create&nbsp;view&nbsp;to&nbsp;zhang1&nbsp;<br>4&gt;&nbsp;go&nbsp;<br>5&gt;&nbsp;grant&nbsp;select,reference&nbsp;on&nbsp;students&nbsp;to&nbsp;zhang1&nbsp;with&nbsp;grant&nbsp;option&nbsp;6&gt;&nbsp;go&nbsp;<br>7&gt;&nbsp;grant&nbsp;update&nbsp;on&nbsp;students(name,native)&nbsp;to&nbsp;zhang1&nbsp;<br>8&gt;&nbsp;go&nbsp;<br>9&gt;&nbsp;sp_helprotect&nbsp;<br>10&gt;&nbsp;go&nbsp;