Some times DBAs get tired of slavery work. One of them is generating database script with management studio.
Database script can be generated with management studio. All objects can be scripted out.
Sometime it is a need to script database out. If you want someone else to do this job, you must give enough permission to perform the job.
The script below grants enough permission.
use [db]
go
grant view definition to [login]
go
grant select on sys.sql_expression_dependencies to [login]
Grant these permission to related person and get rid of a slavery work.
Perfect! I was looking for exact. Stop doing Slavery work.
ReplyDelete