Minimal permissions needed to generate a script of all of a databa

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eyal Shahar - 18 Nov 2008 09:34 GMT

Hi,
Could anyone tell me what are the Minimal permissions needed to generate a
script of all of a database's objects? I want to have a daily job doing that
for me, collecting the scripts from some servers, running as a user with
minimal permissions.
Thanks.

Signature

Eyal Shahar

Reply to this Message

Uri Dimant - 18 Nov 2008 11:32 GMT

Eyal shalom
I believe you should be either db owner or having access to the 'scripted'
database

> Hi,
> Could anyone tell me what are the Minimal permissions needed to generate a
[quoted text clipped - 3 lines]
> minimal permissions.
> Thanks.

Reply to this Message

Erland Sommarskog - 18 Nov 2008 22:02 GMT

> Could anyone tell me what are the Minimal permissions needed to generate
> a script of all of a database's objects? I want to have a daily job
> doing that for me, collecting the scripts from some servers, running as
> a user with minimal permissions.

GRANT VIEW DEFINITION TO minimal_user

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message