November 1, 2007 at 3:59 am
No,
Datareader only has Select permission on all tables and views.
Unfortunately there's no such role as ExecuteAll, you have to create your own db_role.
[font="Verdana"]Markus Bohse[/font]
November 1, 2007 at 4:29 am
Maybe the following script will be useful specially if database contains a huge number of SP, functions,...
declare @Name nvarchar(64)
declare @cmd nvarchar(200)
declare @user sysname
set @user = N'DBUser'
declare c1 cursor for
select [name] from sysobjects
where type in ('P', 'FN', 'TF', 'IF')
order by name
open c1
fetch next from c1 into @Name
while @@fetch_status=0
begin
select @cmd = 'Grant execute on ' + @Name + ' to ' + @user
--exec(@cmd)
print @cmd
fetch next from c1 into @Name
end
close c1
deallocate c1
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply