February 15, 2019 at 11:01 am
Hello,
I will be transfering some procs from dbo to another schema but want the users to have same permissions on this schema as well. I understand moving to a new schema removes the users permissions. What is the best way to handle this?
Thanks a ton in advance
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
February 15, 2019 at 12:26 pm
Well one option instead of actually transferring them would be to script out the create statements with permissions and do a replace on the old schema name with the new one then drop the procedures from the old schema.
February 15, 2019 at 2:15 pm
I thought of the same. However, it appears there are close to 4k procs and I am looking at transferring around 2.5k. I felt scripting out will be taking long time compared to grant permissions after transferring.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply