You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

Idera common framework provides the functionality to add, edit, and delete users and groups while also managing their roles. SQL Inventory Manager leverage this user role functionality to allow you to easily manage the instance permissions associated with your accounts.

There are three roles available:

  • Administrator
  • User
  • Guest

The Administrator role has privileges to access all instances. If you assign the User or Guest role to a user account, Idera allows you to select whether you want to allow the user to access all SQL Server instances or a select few. Choose the Select Specific Instance option, and SQL Inventory Manager displays the Per Instance Tag and Per Instance lists, as shown in the following image. Select a tag, and the user has access to view all instances under that tag. Note that you can select a combination of tags and individual instances. Click the tag name to view a list of all instances under that tag.

Granting permissions through tags applies to instance tags only. A database tag does not grant Guest users access to the host server unless that server also has that tag.

Topics that include steps on managing user accounts and their roles include:

User role permissions

Use the following table as a guide to the available user roles and their permissions.

SQL IM ViewAdministrator roleUser roleGuest role
Overview
Overview (View)All instancesOnly those instances to which the user has accessOnly those instances to which the user has access

Health Check Recommendations (View, export, hide, show details, refresh)

All instancesOnly those instances to which the user has accessOnly those instances to which the user has access

Health Check Recommendations (Dismiss)

All instancesOnly those instances to which the user has accessNOT ALLOWED

SQL Server instances (Add)

ALLOWEDALLOWEDNOT ALLOWED

Tags displayed in sidebar

All tagsAll tags applied to at least one instance to which the user has accessAll tags applied to at least one instance to which the user has access

Instance Details view

All instancesOnly those instances to which the user has accessOnly those instances to which the user has access
Explorer view
Explorer (View)All instancesOnly those instances to which the user has accessOnly those instances to which the user has access
Filtering attributes (Tag/Location/Owner/Version/etc.)ALLOWEDAll tags applied to at least one instance to which the user has accessAll tags applied to at least one instance to which the user has access
Instances view
Instances listAll instancesOnly those instances to which the user has accessOnly those instances to which the user has access
Filtering attributes (Tag/Location/Owner/Version/etc.)ALLOWEDAll tags applied to at least one instance to which the user has accessAll tags applied to at least one instance to which the user has access
Instances > Managed or SQL Licensing tab

SQL Server instances (Add)

ALLOWEDALLOWEDNOT ALLOWED
Details (View)All instancesOnly those instances to which the user has accessOnly those instances to which the user has access
Refresh DataAll instancesOnly those instances to which the user has accessOnly those instances to which the user has access
Edit PropertiesAll instancesOnly those instances to which the user has accessNOT ALLOWED
Edit TagsAll instancesOnly those instances to which the user has accessNOT ALLOWED
ExportAll instancesOnly those instances to which the user has accessOnly those instances to which the user has access
More Actions > RemoveAll instancesOnly those instances to which the user has accessNOT ALLOWED
More Actions > Disable MonitoringAll instancesOnly those instances to which the user has accessNOT ALLOWED
Instances > Discovered tab
IgnoreALLOWEDOnly those instances to which the user has accessNOT ALLOWED
Auto Registration OptionsALLOWEDNOT ALLOWEDNOT ALLOWED
Discover InstancesALLOWEDNOT ALLOWEDNOT ALLOWED
Instances > Ignored tab
Move to DiscoveredALLOWEDOnly those instances to which the user has accessNOT ALLOWED
Administration view
Manage UsersALLOWED  
Add SQL Server InstanceALLOWEDALLOWEDNOT ALLOWED
Import SQL ServersALLOWEDALLOWEDNOT ALLOWED
Configure Email (SMTP) SettingsALLOWEDNOT ALLOWEDNOT ALLOWED
Subscribe to AlertsALLOWEDALLOWEDNOT ALLOWED
Manage Subscriptions for All UsersALLOWEDNOT ALLOWEDNOT ALLOWED
Manage Health ChecksALLOWEDNOT ALLOWEDNOT ALLOWED
Manage LicenseALLOWEDNOT ALLOWEDNOT ALLOWED
Manage TagsALLOWEDNOT ALLOWEDNOT ALLOWED
Manage Discovery OptionsALLOWEDNOT ALLOWEDNOT ALLOWED
Auto Registration OptionsALLOWEDNOT ALLOWEDNOT ALLOWED
Discover InstancesALLOWEDALLOWEDNOT ALLOWED

 

Need more help? Search the Idera Customer Support Portal.

 

 

 

 

 

  • No labels