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.

permission Specifies a permission that can be granted on a database. For a list of the permissions, see the Remarks section later in this topic. ALL This option does not grant all possible permissions ...

In SQL Server, the user's permission are managed either by adding user to the roles or groups. Roles can be user defined or existing database roles.

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

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

8) You don’t need to assign any permissions on the SQL Server. As long as the user exists on SQL, then you can use it, and assign permissions from a NAV client. 9) So open the database in NAV, and go ...