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
 .NET Inside SQL Server (2005)
 Role Permissions

Author  Topic 

jayasree_tella@yahoo.com
Starting Member

2 Posts

Posted - 2008-04-11 : 09:55:28
Hi Guys,

How to copy one user role permissions to another role in same databse using stored procedue(sp)? Can any one help how to write sp.

Thanks.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-11 : 17:26:53
What do you mean? Be clear
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-12 : 01:20:04
Script permission of one role, modify role name in the script then run it.
Go to Top of Page
   

- Advertisement -