February 23, 2007 at 8:02 am
Sometimes, I got request for some users. They would like to have the same permissions after someone else. How to do it?
Many thanks in advance.
February 23, 2007 at 8:23 am
The easiest way is to create roles and assign permissions to them. Then, all users that need the same permissions can be made members of the same role(s).
John
February 26, 2007 at 1:08 pm
I knew the way you described in the easiest way for multi-users. However, sometimes, one user loginID has been created. Then, I got a request to create a new loginID after the first one. Could you do it without creating a new role?
Many thanks in advance.
February 27, 2007 at 1:56 am
Probably the best way is to insert the result set of sp_helprotect @username='olduser' into a temp table and use that to build a script to grant or deny permissions as appropriate. I would recommend that if you do this, you do it for a role. Make the new and old users members of that role and then you only have to do it once.
John
February 27, 2007 at 3:26 pm
John:
Thank you very much for your input. We should use sysusers to retrieve info on basic roles, sysprotects to retrieve info on detail permissions.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply