Getting Role and Permissions from DB

Hi Guys,

  We have to many times create/drop/modify the tables in our db,as still db changes
  are going thru. But whenever this happens the permissions are lost on certain roles.

 Also soon we may have to move the db to a new server for testing for QA's.But this
 time I wanted that we don't have to go thru the same pain and loose two days to again figure out
 what objects lost the permissions in certain roles.

Is there any commands that we can use to restore the same privilges whenever we move to
 another db or do chnages in same db.??

Please let me know

Thanks for any help

Manoj Received on Thu Dec 31 1998 - 08:43:16 CST