EXTRACT DATABASE PERMISSIONS SQL SERVER

the script to extract the complete database permission along with the database role and application role.h(Before refres)NOTE: the application role(if present) will be created with the different password. Please change it after refreshing the database.Before refershing the databa

 
 
 
 
 
4.3 Star
(7)
2,756 times
Add to favorites
Databases
4/27/2016
E-mail Twitter del.icio.us Digg Facebook
  • Hi doesn't seem to work
    2 Posts | Last post April 27, 2016
    • Got this error
      Msg 208, Level 16, State 1, Line 313 
      Invalid object name 'information_schema.SCHEMATA'.
    • IT is because your databases doesn't have schema owner.
      i have updated the script. please try again.
      
      Thanks.