Copy permissions from user/group to different user/group 
Author Message
 Copy permissions from user/group to different user/group
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



Tue, 18 May 2004 15:48:58 GMT
 Copy permissions from user/group to different user/group

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!



Tue, 18 May 2004 23:23:06 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Informix User Group - Forum 2000 - A Two Day User Group Technical

2. The User Group News: South Florida Informix User Group meeting

3. Need SQL Script to reverse-engineer datbase users, groups, permissions for SQL 6.5

4. 6.5 Group/User Permissions

5. Inheriting user groups / permissions

6. User Permissions on a table group

7. user/group permissions

8. Create Table Permission for Domain Users Group

9. Possible Bug - Grant Object Permissions by User and Group Not Working

10. how can I retreive Users,Groups and Permissions

11. seting group and user permissions

12. user and group permission - Access database


 
Powered by phpBB® Forum Software