为了防止用户查看SQL Server 2008中的存储过程和其他安全对象,可以采取以下措施:
CREATE LOGIN [username] WITH PASSWORD = 'password';
CREATE USER [username] FOR LOGIN [username];
GRANT EXECUTE ON [schema].[stored_procedure] TO [username];
CREATE ROLE [role_name];
GRANT EXECUTE ON [schema].[stored_procedure] TO [role_name];
EXEC sp_addrolemember 'role_name', 'username';
ALTER PROCEDURE [schema].[stored_procedure] WITH ENCRYPTION;
腾讯云相关产品和产品介绍链接地址:
领取专属 10元无门槛券
手把手带您无忧上云