August 28, 2010 at 6:39 am
Hello,
I have many tables in DB, and one user with different permission on tables and columns.
Is there any way how to create script with these permission?
thx.
Radek
August 28, 2010 at 9:23 am
Try the scripts from this article:
http://www.mssqltips.com/tip.asp?tip=2048
or this one
http://www.mssqltips.com/tip.asp?tip=1881&home
or this one (output into html)
http://www.mssqltips.com/tip.asp?tip=1818
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 28, 2010 at 9:26 am
I forgot to mention one last one. Here is a post I wrote on what I used for this.
http://jasonbrimhall.info/2010/03/19/security-audit/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply