Permissions for SQL users

#1

What kind permissions I need to grant to a SQL user so
this user can see all my scheduled job?
Thanks for help.

-George

#2

In article <42ca01c3aad9$82e72f40$a601280a (AT) phx (DOT) gbl>, George
<anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

What kind permissions I need to grant to a SQL user so
this user can see all my scheduled job?
Thanks for help.

-George

You can only view jobs you own unless you are a sysadmin.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

#3

Or the TargetServersRole which exists inside the MSDB system database.
Member of this role can start/ stop jobs, delete jobs, view jobs on the
server and view job history (even the jobs that are not owned by them).

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Darren Green" <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in
message news:$YlxaPLvGXt$Ewbl (AT) sqldts (DOT) com...

Quote:

In article <42ca01c3aad9$82e72f40$a601280a (AT) phx (DOT) gbl>, George
anonymous (AT) discussions (DOT) microsoft.com> writes
What kind permissions I need to grant to a SQL user so
this user can see all my scheduled job?
Thanks for help.

-George

You can only view jobs you own unless you are a sysadmin.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

#4

TargetServersRole works!
Thank you very much for the recommendation.

-George

Quote:

-----Original Message-----
Or the TargetServersRole which exists inside the MSDB
system database.
Member of this role can start/ stop jobs, delete jobs,
view jobs on the
server and view job history (even the jobs that are not
owned by them).

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Darren Green" <darren.green@reply-to-newsgroup-
only.uk.com> wrote in
message news:$YlxaPLvGXt$Ewbl (AT) sqldts (DOT) com...
In article <42ca01c3aad9$82e72f40$a601280a (AT) phx (DOT) gbl>,
George
anonymous (AT) discussions (DOT) microsoft.com> writes
What kind permissions I need to grant to a SQL user so
this user can see all my scheduled job?
Thanks for help.

-George

You can only view jobs you own unless you are a
sysadmin.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server
professionals
http://www.sqlpass.org

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Permissions for SQL users

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Permissions for SQL users - 11-14-2003 , 12:02 PM

Re: Permissions for SQL users - 11-14-2003 , 06:22 PM

Re: Permissions for SQL users - 11-16-2003 , 05:54 AM

Re: Permissions for SQL users - 11-16-2003 , 04:13 PM