July 6, 2006 at 7:58 am
How can I copy same permissions in one login to other newly created login?
July 6, 2006 at 10:40 am
Well, I have never really done this, so, I only offer the following suggestion...
I guess I would start by right clicking on the db -> All Tasks -> generate SQL script, then under options, click Script Database Users and roles and go back to the general tab and preview...
Good luck
-- Cory
July 7, 2006 at 8:52 am
You could use roles instead of assigning permissions to individual users. Then all you need to do is assign the permissions to the role, put the new user in the role and you don't need to copy any permissions at all.
John
July 7, 2006 at 9:04 am
Roles are the way to go. Specifically to avoid this issue.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply