Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

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

 
   Database Help (Home) -> Security RSS
Next:  like does not work on SQL2000  
Author Message
Eyal Shahar

External


Since: Nov 17, 2008
Posts: 2



(Msg. 1) Posted: Tue Nov 18, 2008 1:34 am
Post subject: Minimal permissions needed to generate a script of all of a databa
Archived from groups: microsoft>public>sqlserver>security (more info?)

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.

--
Eyal Shahar

 >> Stay informed about: Minimal permissions needed to generate a script of all of .. 
Back to top
Login to vote
Uri Dimant

External


Since: Aug 24, 2003
Posts: 1744



(Msg. 2) Posted: Tue Nov 18, 2008 7:25 am
Post subject: Re: Minimal permissions needed to generate a script of all of a databa [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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





"Eyal Shahar" wrote in message

> 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.
>
> --
> Eyal Shahar

 >> Stay informed about: Minimal permissions needed to generate a script of all of .. 
Back to top
Login to vote
Erland Sommarskog2

External


Since: May 30, 2004
Posts: 2061



(Msg. 3) Posted: Tue Nov 18, 2008 2:02 pm
Post subject: Re: Minimal permissions needed to generate a script of all of a databa [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Eyal Shahar ( ) writes:
> 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


--
Erland Sommarskog, SQL Server MVP, esquel RemoveThis @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
 >> Stay informed about: Minimal permissions needed to generate a script of all of .. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL CLR permissions needed after deployment to target serv.. - I am working on my first CLR project, having progressed to the point where I have a working version in VS2008. Project is set to "external", and the assembly is signed with a PFX file. On both servers, I am running in the role of sysadmin, ...

Permissions Across Databases - I have two databases. In the first database I have a view that needs to be able insert into a table in the second database. I want the user to only have select permissions in the second database’s table. Because of this restriction the view canno...

Where are the permissions documented? - Under what topic in BOL is the meaning of the various permissions such as "Alter", "References", etc., documented? In other words, where is it documented, what you can DO if you have been granted "References" or "Imp...

Table Permissions - I'm assuming that its possible to restrict a user to read-only access for any particular table in a database?

Cannot Generate SSPI context, Running Jobs in SQL Server 2.. - Hi I am Using SQL 2005 and running Jobs I am getting the following error DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Cannot generate SSPI context Error source: Microsoft OLE DB Provider for SQL..
   Database Help (Home) -> Security All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]