{"id":1943,"date":"2012-02-25T03:00:16","date_gmt":"2012-02-25T03:00:16","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=1943"},"modified":"2013-11-01T04:52:55","modified_gmt":"2013-11-01T04:52:55","slug":"%e7%94%a8%e6%88%b7%e6%9d%83%e9%99%90%e6%9f%a5%e8%af%a2","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2012\/02\/25\/%e7%94%a8%e6%88%b7%e6%9d%83%e9%99%90%e6%9f%a5%e8%af%a2\/","title":{"rendered":"\u7528\u6237\u6743\u9650\u67e5\u8be2"},"content":{"rendered":"<div>\n\t&#8211;\u5f00\u8fde\u63a5<\/div>\n<div>\n\tCREATE USER [zinnova] FOR LOGIN [zinnova]<\/div>\n<div>\n\tGO<\/div>\n<div>\n\t&nbsp;<\/div>\n<div>\n\t&#8211;\u5f00\u8868<\/div>\n<div>\n\tGRANT SELECT ON OBJECT::dbo.mdOrderStatus TO zinnova;<\/div>\n<div>\n\tGO<\/div>\n<div>\n\t&nbsp;<\/div>\n<div>\n\t&#8211;\u67e5\u770b SQL 2005 \u7528\u6237\u88ab\u8d4b\u4e88\u7684\u6743\u9650<\/div>\n<div>\n\texec sp_helprotect @username = &#39;zinnova&#39;<\/div>\n<div>\n\t&nbsp;<\/div>\n<div>\n\t&#8211;\u67e5\u770b\u7528\u6237\u89d2\u8272<\/div>\n<div>\n\tselect DbRole = g.name, MemberName = u.name, MemberSID = u.sid<\/div>\n<div>\n\tfrom sys.database_principals u, sys.database_principals g, sys.database_role_members m<\/div>\n<div>\n\twhere g.principal_id = m.role_principal_id<\/div>\n<div>\n\tand u.principal_id = m.member_principal_id<\/div>\n<div>\n\torder by 1, 2<\/p>\n<p>\t&#8211;\u5bf9\u8c61\u7684\u53d6\u5f97\u6240\u6709\u6743\u4e0e\u63a7\u5236\u7684\u6743\u9650\u533a\u522b<br \/>\n\t&#8211;\u7ecf\u6d4b\u8bd5\uff1a\u53d6\u5f97\u6240\u6709\u6743\u7684\u6743\u9650\u53ef\u4ee5deny,\u800c\u63a7\u5236\u6743\u9650\u5ffd\u7565deny<\/div>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;\u5f00\u8fde\u63a5 CREATE USER [zinnova] FOR LOGIN [zinnova] GO [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-1943","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/1943","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=1943"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/1943\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=1943"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=1943"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=1943"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}