sqlÖÐdboÊÇʲôÒâ˼
sql server ÖÐµÄ dbodbo ÊÇ database owner£¨Êý¾Ý¿âËùÓÐÕߣ©½ÇÉ«£¬ÓµÓÐÒÔÏÂÆÕ±éȨÏÞ£º½¨Éè¡¢Ð޸ĺÍɾ³ýÊý¾Ý¿â¹¤¾ßÖÎÀíÓû§ºÍȨÏÞÖ´Ðб¸·ÝºÍ»¹Ô²Ù×÷ÐÞ¸ÄÊý¾Ý¿âÉèÖÃdbo ½Çɫͨ³£ÔÚÊý¾Ý¿â½¨Éèʱ×Ô¶¯½¨É裬²¢ÊÚÓè¸ø½¨ÉèÊý¾Ý¿âµÄÓû§¡£
SQL ÖÐµÄ dbo
dbo ÔÚ SQL Server Öдú±í Database Owner£¨Êý¾Ý¿âËùÓÐÕߣ©¡£ËüÊÇÒ»¸öÌØÊâµÄÊý¾Ý¿â½ÇÉ«£¬Í¨³£ÊÚÓèÊý¾Ý¿âµÄËùÓÐÕß»òÖÎÀíÕß¡£
×÷ÓÃ
dbo ½ÇÉ«¾ßÓжÔÊý¾Ý¿âµÄÆÕ±éȨÏÞ£¬°üÀ¨£º
½¨Éè¡¢Ð޸ĺÍɾ³ýÊý¾Ý¿â¹¤¾ß£¨±í¡¢ÊÓͼ¡¢´æ´¢Àú³ÌµÈ£©
ÖÎÀíÓû§ºÍȨÏÞ
Ö´Ðб¸·ÝºÍ»¹Ô²Ù×÷
ÐÞ¸ÄÊý¾Ý¿âÉèÖÃ
ÊÚÓè
dbo ½Çɫͨ³£ÔÚÊý¾Ý¿â½¨Éèʱ×Ô¶¯½¨É裬²¢ÊÚÓè¸ø½¨ÉèÊý¾Ý¿âµÄÓû§¡£Ò²¿ÉÒÔͨ¹ýÒÔÏÂÓï¾äÊÖ¶¯ÊÚÓè dbo ½ÇÉ«£º
GRANT db_owner TO [user_name]
µÇ¼ºó¸´ÖÆ
×¢ÖØÊÂÏî
ËäÈ» dbo ½ÇÉ«¾ßÓÐÇ¿Ê¢µÄȨÏÞ£¬µ«ÆäʹÓÃÓ¦ÉóÉ÷¡£ÊÚÓè¹ý¶àÓû§ dbo ½ÇÉ«¿ÉÄܵ¼ÖÂÊý¾Ý¿âÇå¾²ÐÔºÍÍêÕûÐÔÊÜËð¡£Òò´Ë£¬Ò»Ñùƽ³£½¨ÒéÖ»½« dbo ½ÇÉ«ÊÚÓèȷʵÐèÒªÆäȨÏÞµÄÓû§¡£
ÓëÆäËû½ÇÉ«µÄ½ÏÁ¿
SQL Server ÖÐÉÐÓÐÆäËûÊý¾Ý¿â½ÇÉ«£¬¾ßÓвî±ðµÄȨÏÞ¼¶±ðºÍÄ¿µÄ¡£³£¼ûµÄ½ÇÉ«°üÀ¨£º
db_reader£ºÔÊÐíÔĶÁÊý¾Ý¿âÖеÄÊý¾Ý
db_writer£ºÔÊÐíÐÞ¸ÄÊý¾Ý¿âÖеÄÊý¾Ý
db_datareader£ºÔÊÐí¶ÁÈ¡±íÖеÄÊý¾Ý£¬µ«²»¿ÉÐÞ¸Ä
db_datawriter£ºÔÊÐíÐ޸ıíÖеÄÊý¾Ý£¬µ«²»¿É¶ÁÈ¡
ÒÔÉϾÍÊÇsqlÖÐdboÊÇʲôÒâ˼µÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡