给用户添加执行存储过程权限

1.创建给用户添加执行存储过程权限的存储过程

create procedure p_addexec  create procedure p_addexec

@username varchar(50) @username varchar(50)

as as

CREATE ROLE [execp] AUTHORIZATION [dbo] CREATE ROLE [execp] AUTHORIZATION [dbo]

declare @strRole varchar(50) declare @strRole varchar(50)

declare @str varchar(5000) declare @str varchar(5000)

set @str= set @str=

set @strRole=execp set @strRole=execp

select @str=@str+grant execute on +name+ to +@strRole+; from sysobjects where xtype= p  select @str=@str+grant execute on +name+ to +@strRole+; from sysobjects where xtype= p

exec (@str) exec (@str)

EXEC sp_addrolemember Nexecp,@username EXEC sp_addrolemember Nexecp,@username

GO GO

create procedure p_addexec @username varchar(50) as CREATE ROLE [execp] AUTHORIZATION [dbo] declare @strRole varchar(50) declare @str varchar(5000) set @str= set @strRole=execp select @str=@str+grant execute on +name+ to +@strRole+; from sysobjects where xtype= p exec (@str) EXEC sp_addrolemember Nexecp,@username GO

2.执行 2.执行

exec p_addexec 用户名 exec p_addexec 用户名

1.创建给用户添加执行存储过程权限的存储过程 create procedure p_addexec @username varchar(50) as CREATE ROLE [execp] AUTHORIZATION [dbo] declare @strRole varchar(50) declare @str varchar(5000) set @str= set @strRole=execp select @str=@str+grant execute on +name+ to +@strRole+; from sysobjects where xtype= p exec (@str) EXEC sp_addrolemember Nexecp,@username GO 2.执行 exec p_addexec 用户名

1.创建给用户添加执行存储过程权限的存储过程 create procedure p_addexec @username varchar(50) as CREATE ROLE [execp] AUTHORIZATION [dbo] declare @strRole varchar(50) declare @str varchar(5000) set @str= set @strRole=execp select @str=@str+grant execute on +name+ to +@strRole+; from sysobjects where xtype= p exec (@str) EXEC sp_addrolemember Nexecp,@username GO 2.执行 exec p_addexec 用户名