Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Copying database level user securables

Author  Topic 

Roomurray
Starting Member

4 Posts

Posted - 2011-04-01 : 03:51:36
Hi All,

My first post - so hello :)

I hope someone can help. I have a number of databases on one server and I have selected user securables on the tables on each of these. I have had to set up some more users (all windows log-ons) and want to copy these securities from one user to another.

Most of the securibles are to deny view definition.

IS there a script I can use to perform this?
   

- Advertisement -