DataSight database security is a combination of Microsoft SQL Server security coupled with DataSight application security. Both forms of security need to be implemented.

DataSight Administrator helps you:

• Create and authenticate Microsoft SQL server accounts for DataSight databases. Users, once created and assigned a group, may be authenticated as a Windows user or Microsoft SQL Server user.

See Accounts and Modes of User Authentication

• Assign and grant users permissions to various databases and DataSight modules. Having groups of users can make changing security settings easier in DataSight, so that permissions can be changed on a group scale, rather than making individual permission changes for each user.

See Permissions

Accounts may be either a user or a group and have a distinct set of application permissions. These accounts are the same as seen within the DataSight client application.

DataSight has one built-in application security group called "Admin". When a user is assigned to this group, they will by default have full administrative rights to manage accounts and their permissions. When a new DataSight database is created, the user logged into DataSight Administrator will be the db_owner of that database and will be assigned to the Admin group.

The DataSight Admin group rights should not be confused with that of an IT Administrator for the Microsoft SQL Server instance. A DataSight user with Admin group permissions can alter the application security of DataSight databases created on an Microsoft SQL Server instance, however they should not necessarily have full Microsoft SQL Server rights to create or delete databases. An IT Administrator for an Microsoft SQL Server instance housing several databases must maintain strict Microsoft SQL Server security policies. For standalone installations of DataSight on Microsoft SQL Express, the Microsoft SQL Server administrator and the DataSight administrator could be one and the same.

Open User Management from the DataSight Administrator Ribbon

• Click User Management in the User Group of the DataSight Administrator Ribbon. The Security Window appears.

See also:

• Set Accounts
• Set Permissions