为SQLServer2005添加帐户和授权.

EXEC sp_addlogin 'jinho', '0000'
GO

USE productDB
GO
EXEC sp_grantdbaccess 'trafficManager','manager'
EXEC sp_grantdbaccess 'seller','seller'
GO

USE productDB
GO
GRANT select,insert,update,delete on proInfo to jinho
GRANT select on proInfo to jinho
GO

“七”乐无穷，尽在新浪新版博客，快来体验啊~~~请点击进入~

转载于:https://www.cnblogs.com/jinho/archive/2010/03/29/1700129.html