This script will generate permissions for every user in the database, and it will run on every database on the instance.
Just paste and run the script.
mobasha,
2008-05-06 (first published: 2008-03-06)
This script will generate permissions for every user in the database, and it will run on every database on the instance.
Just paste and run the script.
use master go begin declare @databasename varchar(30) declare cur cursor for select name from sysdatabases create table #result (dbname varchar(30),result varchar(300)) open cur fetch next from cur into @databasename while(@@fetch_status=0) begin create table #t (a1 varchar(50) ,a2 varchar(50) ,a3 varchar(50) ,a4 varchar(50) ,a5 varchar(50) ,a6 varchar(50) ,a7 varchar(50)) insert into #t exec sp_helprotect @username = null insert into #result select @databasename,a5+' '+a6+' on ['+a1+'].['+a2+']'+ CASE WHEN (PATINDEX('%All%', a7)=0) and (a7 <> '.') THEN ' ('+a7+')' ELSE '' END+' to ['+a3+']' from #t drop table #t fetch next from cur into @databasename end select * from #result close cur deallocate cur drop table #result end go
This article covers four of the fixed database roles (db_datareader, db_datawriter, db_denydatareader, and db_denydatawriter). If you're new to SQL security (and maybe even if you're not) this article is worth reading.
2003-10-10
10,181 reads
Learn how to secure your data by implementing SQL Server security best practices.
2001-07-19
2,476 reads
2001-06-14
5,534 reads
2001-05-25
3,902 reads