July 21, 2009 at 10:51 am
Hi,
We periodically delete a test database and restore it from production. After the restore, my logins on the test box no longer have read/write/execute etc. rights to the database. What I have been doing is generate a script to delete all users and schema in that database, and execute a script that grant back access. I can see that I can generate a script from the test database before I delete it but it only generates the "create user" part. Not the permissions. Is there a way to generate a script to save the actual rights that were granted to that database? Thank you.
July 21, 2009 at 11:36 am
Right-click on the database name, Tasks, Generate Scripts. If you look at the scripting options, you can set it to script out the permissions.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
July 21, 2009 at 11:42 am
(if you turn off the "create" and "drop" options, you will ONLY get the permissions).
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply