SqlServer ȨÏÞÎÊÌâ

ÈçºÎÉèÖÃsqlserverij¸öÓû§Ö»ÄÜÔËÐд洢¹ý³Ì£¬±ðµÄʲôȨÏÞ¶¼Ã»ÓÐ

---

GRANT all on dbo.proc_1 to user

---

http://wz.cnblogs.com/question/7030/

---

SQL code:
use testdb
go
--ÐÂÔöÓû§
exec sp_addlogin 'testuser' --Ìí¼ÓµÇ¼
exec sp_grantdbaccess N'testuser' --ʹÆä³ÉΪµ±Ç°Êý¾Ý¿âµÄºÏ·¨Óû§

grant create proc to testuser --Ìí¼ÓÖ»ÔÊÐí´´½¨´æ´¢¹ý³ÌȨÏÞ

---

ÒýÓÃ

SQL code
use testdb
go
--ÐÂÔöÓû§
exec sp_addlogin 'testuser' --Ìí¼ÓµÇ¼
exec sp_grantdbaccess N'testuser' --ʹÆä³ÉΪµ±Ç°Êý¾Ý¿âµÄºÏ·¨Óû§

grant create proc to testuser --Ìí¼ÓÖ»ÔÊÐí´´½¨´æ´¢¹ý³ÌȨÏÞ

up
{{