Prasad Bolla's SharePoint Blog: How to give Read Only Permission to a user to SQL Jobs

Friday, May 08, 2015

How to give Read Only Permission to a user to SQL Jobs

use msdb

EXECUTE sp_addrolemember

@rolename = 'SQLAgentReaderRole',

@membername = 'Domain\UserName’

No comments:

Recent Posts this week

Recent Posts This Week
Default Color for Hyperlink
STSADM vs PowerShell
Remodeled Code: Progress Bar in GridView using SharePoint Tasks List
JQuery Plugin 1.9.1 not supporting SPServices
Problem with JQuery Show() Method when an html control is in Show() state.
Insert User into People Picker Column who is not part of SiteCollection
Showing Image Loader while performing Paging in GridView
Windows7 And Windows Server 2008 R2 Not getting Booted in Normal Mode.
Binding items From SharePoint List to Combo Box using SilverLight Client Object Model
Delete a SharePoint ListItem using silverLight Client Object Model
Update a SharePoint ListItem using silverLight Client Object Model
Insertion into a SharePoint List using SilverLight Client Object Model.
System.NullReference Exception in Visual Studio 2010 Silverlight Designer: Resolved
How to show New Image Next to Hyperlink for a Newly Created SharePoint List Item within a GridView
How to Display Ads in Visual WebPart with Ajax Timer Control And Asp.Net Image.
How to retrieve all SharePoint Lists and Libraries using Server Side Linq to GridView
Highlighting Text within a GridView When Performing Search Results from SharePoint
Tip: Getting the Updated WSP File using Visual Studio 2010
How to Retrieve SharePoint Quick Launch Links to GridView or SpGridView using Server Side Linq
Create an XSLTListViewWebPart Programatically with Paging
How to LogOff Windows Server 2012
Binding Data from SharePoint List to GridView using Three Tier Architecture in SharePoint 2013 Visual WebPart without a Single Line of Loop
How to Use Three Tier Architecture in SharePoint 2013 Visual WebPart
My First WebPart in SharePoint 2013
How to Pass Query within a SSRS Report Query Builder.
Adding RDL file to Sql Server Business Intelligence WebPart
How to generate Report from SharePoint List using Sql Server Business Intelligence Development Studio
Live Task Print data from GridView using JQuery
Using SharePoint Objects within a Server Side Linq
SharePoint 2013 Notes
Another way to Find Recycle Bin in SharePoint 2013
How to Open the Admin Recycle Bin in SharePoint 2013
Where do we find Recycle Bin in SharePoint 2013
How to Enable Document Set Feature in SharePoint 2013
Implement Simple Rating Concept in GridView using SharePoint List Data
How to use SharePoint RichTextBox within a Visual webPart
Performing Edit Update and Delete in SharePoint List using GridView Command Fields within a UserControl
Insert Edit Update Delete in GridView using Client Object Model in SharePoint 2010
Using Array to Bind Data from SharePoint List to GridView
Adding attachment to an SharePoint ListItem while Insertion
Generate Asp.Net Server Side Table Dynamically using SharePoint Data
Adding Hyperlink to Asp.Net Bulleted List using SharePoint Data Without a single line of Loop
Binding Data to Asp.Net Bulleted List without a Single line of Loop using SharePoint Data
Retrieving SharePoint List Attachments Programmatically
Retrieve SharePoint List Attachments Dynamically to a GridView or SharePoint GridView
Binding Data to Ajax Acordin Control from SharePoint List Fetching Countries Based on Region
Paging without Refresh in GridView using Visual WebPart
Refresh Your WebPart Page every Five Minutes using Visual WebPart
Building a Group By with Simple HTML Table using SharePoint Object Model
Group By with Asp.Net GridView using SharePoint Object Model
Using GridView Inside a GridView along with Group By Functionality without a single line of Loop using SharePoint Data
Create a New Image Next to GridView Column if the SharePoint List Item Created is the new one
Retrieving Data from Subsite List and Hyperlink for Group by without a Single Line of Loop with Asp.Net GridView
Using View State to increase the Performance in Asp.Net Grid View while retrieving SharePoint Data
Custom Paging with Asp.Net Repeater Control using SharePoint Data
Binding Date along with Time in GridView using SharePoint Data

My BookMarks

My BookMarks
User Profile Import in Moss 2007
Troubleshooting Issues in SharePoint 2007
ULS Logging in SharePoint 2007
Backup & Restore using SharePoint 2007
Define Content Scopes
Configure Search in SharePoint 2007 - Link2
Configure Search in SharePoint 2007 - Link1
Configure SSP in SharePoint 2007
Setup a Multiple Farm Topology in SharePoint 2007
Load Balancer
Hardware Load Balancer
Trace route
Ping Command
Troubleshooting IIS Error Codes
IIS Error Codes
Install & Configure SSL Certificate in IIS7
Installing a SSL Certificate
SSL Certificates
App Pool Troubleshooting
App Pools in IIS
SQL Server Basics
Restore a SQL Server Database using sql server
Backup using SQL Server
High Availability Techniques
Troubleshooting SQL Server Jobs
Insertion into SharePoint List using SpServices & Batch
Insetion Sample without Batch usingSPServices
SpServices Documentation
SharePoint 2013 Text Based Videos
Data View Web Part: Create a Google Pie Chart with XSLT in SharePoint 2010
Example:Create a Graph Like Enironment with DataView WebPart in SharePoint 2007
SharePoint 2013 EBooks Download
Configure FBA in SharePoint 2013
Cannot find Sticky Notes in windows7
Developing Reports without SSRS in SharePoint 2010
Create Menus and Dynamic Menus at the Server Side
SharePoint Server 2010 Service Pack1 Download
SharePoint 2013 Videos
Aircel 3g Plans for Hyderabad
Microsoft SharePoint Team Blog
WCF Tutorial
Streaming videos and downloads for presentations
How to connect Reliance Net Connect to Tab
Microsoft Asp.Net 3.5 Charts Basic Knowledge Part2
Microsoft Asp.Net 3.5 Charts Basic Knowledge Part1
GridView Paging Sample in Asp.Net
How to Create a Custom Site Definition with Additional Content in SharePoint 2010 Using Visual Studio 2010
SharePoint 2010 – Creating a List Definition using SharePoint Designer
Creating SharePoint 2010 List Definitions in Visual Studio 2010
Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source
SkySoft Virtual CloneDrive
Kancharla Srikanth SharePoint Development & Admin Blog
Page Layouts in SharePoint
Lambross Blog on SharePoint & .Net
Create and configure a new Search service application (SharePoint Server 2010)
Learner's Paradise SharePoint Blog
Useful SharePoint Blog
SharePoint 2013 Articles from WssV4 Mind Sharp
CAML Designer
Capabilities & Features of SharePoint 2013
SharePoint 2013 Notes
Download SharePoint 2013 Beta
SharePoint 2013 Videos
SharePoint 2013 IT Professional Training
Sample Code Update & Delete in GridView
SpGridView and SpMenu Fileld
Harry Chen's SharePoint Blog
Step by Step – Building and Consuming Custom WCF Services Hosted in IIS using WCF Application Approach
WCF ToolKit for Visual Studio 2010
How to Programmatically Upload the files and folders to a sharepoint Document library,Update and Delete Files from sharepoint sites
Underlying Connection was closed error KB Article
GridView Examples for ASP.NET 2.0: Working with TemplateFields
Hardware and Software Requirements for Installing SQL Server 2008 R2
Download U2U Softwares
Download Sky Drive Explorer
How to use SharePoint 2010 Co-RelationID Error Messages
Ammol Rehan SharePoint Blog
Basant Pandey SharePoint Blog
Using Ajax Control Tookit in SharePoint 2010
Saji Viswam's SharePoint Blog
Sohel's SharePoint Blog
Zimmergren SharePoint Blog
Suresh NV SharePoint Blog
Shivacharan SharePoint Blog
Purnachander SharePoint Blog
Praveen Battula SharePoint Blog
How to Enable Rating in SharePoint 2010
How to setup XP Mode on Windows 7
Creating a Custom List Definition in SharePoint 2007
Learn SharePoint 2007 Customization
Chris Obrien SharePoint Blog
Famous Asp.Net Blog
SharePoint 2010 Videos for Developers
SharePoint 2010 FBA Part2
SharePoint 2010 FBA Part1

Android Apps

Android Apps
Kingsoft Office 5.3.4
Whats App Free Talking App for Android
Viber Free Talking App for Android
Tango Free Talking App for Android
You see Browser for Android
Software to connect Reliance NetConnect and Tata Photon to Android Tablet.
Telugu Radio App for Android
Winamp App for Android
Stick Cricket App for Andriod
Talking Tom Cat 2 Free
Firefox Browser for Android

Friday, May 08, 2015

How to give Read Only Permission to a user to SQL Jobs

No comments:

Post a Comment