You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.

3] Setting up rules for the users to access the FTP Folder. In this step, we will configure the FTP Server to allow the newly created user accounts to access it.

SQL Server Permission Manager is a suite of scripts that allows you to take "snapshots" of users and permissions across any or all of the databases on your SQL Server. These snapshots then allow you ...

Hoping to pull from the hive mind on this one. I'm wondering if there is a way for someone to be able to do maintenance work on a sql server without actually being able to look at the data. What ...

Use the following steps to grant an existing database user db_owner permissions. Theses steps assume that you are connected to SQL Database in Object Explorer in SSMS and are connected to your SQL ...

There's a catch: They have to bring their workloads to the Azure cloud. But for some users, this could be a feasible option. Extended support for SQL Server 2008 and 2008 R2 is set to end in July ...

Today we are extending our look at user accounts by creating database users and then adding them to specific roles for to provide the proper level of access to a database. First thing is first: we ...

Add Picture; Add a Text Input Control which will allow you to enter in the name of the file; Add a button to the canvas, this will allow you to take the file / input the user has entered and save it ...