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:
- How to manage users
- Managing users in the Idera Dashboard
- Managing users in SQL Inventory Manager
- Managing users and their subscriptions
User role permissions
Use the following table as a guide to the available user roles and their permissions.
SQL IM View | Administrator role | User role | Guest role |
---|---|---|---|
Overview | |||
Overview (View) | All instances | Only those instances to which the user has access | Only those instances to which the user has access |
Health Check Recommendations (View, export, hide, show details, refresh) | All instances | Only those instances to which the user has access | Only those instances to which the user has access |
Health Check Recommendations (Dismiss) | All instances | Only those instances to which the user has access | NOT ALLOWED |
SQL Server instances (Add) | ALLOWED | ALLOWED | NOT ALLOWED |
Tags displayed in sidebar | All tags | All tags applied to at least one instance to which the user has access | All tags applied to at least one instance to which the user has access |
Instance Details view | All instances | Only those instances to which the user has access | Only those instances to which the user has access |
Explorer view | |||
Explorer (View) | All instances | Only those instances to which the user has access | Only those instances to which the user has access |
Filtering attributes (Tag/Location/Owner/Version/etc.) | ALLOWED | All tags applied to at least one instance to which the user has access | All tags applied to at least one instance to which the user has access |
Instances view | |||
Instances list | All instances | Only those instances to which the user has access | Only those instances to which the user has access |
Filtering attributes (Tag/Location/Owner/Version/etc.) | ALLOWED | All tags applied to at least one instance to which the user has access | All tags applied to at least one instance to which the user has access |
Instances > Managed or SQL Licensing tab | |||
SQL Server instances (Add) | ALLOWED | ALLOWED | NOT ALLOWED |
Details (View) | All instances | Only those instances to which the user has access | Only those instances to which the user has access |
Refresh Data | All instances | Only those instances to which the user has access | Only those instances to which the user has access |
Edit Properties | All instances | Only those instances to which the user has access | NOT ALLOWED |
Edit Tags | All instances | Only those instances to which the user has access | NOT ALLOWED |
Export | All instances | Only those instances to which the user has access | Only those instances to which the user has access |
More Actions > Remove | All instances | Only those instances to which the user has access | NOT ALLOWED |
More Actions > Disable Monitoring | All instances | Only those instances to which the user has access | NOT ALLOWED |
Instances > Discovered tab | |||
Ignore | ALLOWED | Only those instances to which the user has access | NOT ALLOWED |
Auto Registration Options | ALLOWED | NOT ALLOWED | NOT ALLOWED |
Discover Instances | ALLOWED | NOT ALLOWED | NOT ALLOWED |
Instances > Ignored tab | |||
Move to Discovered | ALLOWED | Only those instances to which the user has access | NOT ALLOWED |
Administration view | |||
Manage Users | ALLOWED | ||
Add SQL Server Instance | ALLOWED | ALLOWED | NOT ALLOWED |
Import SQL Servers | ALLOWED | ALLOWED | NOT ALLOWED |
Configure Email (SMTP) Settings | ALLOWED | NOT ALLOWED | NOT ALLOWED |
Subscribe to Alerts | ALLOWED | ALLOWED | NOT ALLOWED |
Manage Subscriptions for All Users | ALLOWED | NOT ALLOWED | NOT ALLOWED |
Manage Health Checks | ALLOWED | NOT ALLOWED | NOT ALLOWED |
Manage License | ALLOWED | NOT ALLOWED | NOT ALLOWED |
Manage Tags | ALLOWED | NOT ALLOWED | NOT ALLOWED |
Manage Discovery Options | ALLOWED | NOT ALLOWED | NOT ALLOWED |
Auto Registration Options | ALLOWED | NOT ALLOWED | NOT ALLOWED |
Discover Instances | ALLOWED | ALLOWED | NOT ALLOWED |
Need more help? Search the Idera Customer Support Portal.