Copy permissions from user/group to different user/group

Copy permissions from user/group to different user/group

Post by Thomas Scho » Sat, 01 Dec 2001 16:48:58



Is there an easy way to copy all the permissions on views/tables/sps
from one user or role to a different user/role?

Thomas Schoch
Thomas Schoch
Elephant Software AG
Switzerland

 
 
 

Copy permissions from user/group to different user/group

Post by Pat Phela » Sun, 02 Dec 2001 00:23:06


The easiest way is to create groups, and assign users to those groups.  Grant permissions to the groups instead of the users.  Voila, this makes it easy!

Short of that, you can easily query the system tables to find the permissions that a given user has.  This would allow you to write a simple stored procedure that would "clone" one users permissions to another user.

-PatP

========================================

Please post DDL at the very least, and DML when possible to make it easier for people to help you.

Please reply only via newsgroups, as I rarely reply to email.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!