Page History

To manage users Instance Level Security go to the SQL BI Administration tab and click Application Security. In the Manage Users window, you can view a list detailing user account, permission level, and instances assigned to the account.  Users Users with different permission levels for different instances are listed multiple times. When a user has multiple instances with the same permission level, instances are grouped on the Accessible Instances column, an ellipsis symbol displays if the names do not fit in the column, to view a complete list hover the mouse over the column.

Adding users

...

You can assigning assign two different access levels to limit users access to managed instances:

View

...

Only: Users can only view

...

their assigned instances.

Modify users can modify configurations and view data from Modify: Users can view and change the configuration of their assigned instances.

To add new users follow these steps: 

1. In the Manage Users screen, click Add User/Group.
    Image Added
   
   
2. In the Add User wizard, type a user name on the search box or click Users to select users from a list, you can select one or more users at a time. Once you select users, click Next.
   Image Added
   
   
3. in the Permissions screen, assign the access level View Only or Modify. Make your selection and click Next.
   Image Added
   
   
4. In the Add  Instances screen, you can select one or more instance and service combinations. 
   • Select one or more specific instances and services and click  >  Image Added . 
   • Click >>  Image Addedto assign all the listed instances and services.
   Image Added
   
   
5. When you finish assigning instances, click Next.
6. In the Finish screen screen, click Back to make changes in your settings, to continue click FinishSubmit.
   Image Added
   
   

Editing users

1. To edit users open the Manage Users window, select a user, and click Edit User. 
2. In On the Permissions window, select the permission level for the user and click Next. 
3. In On the Instances window you can , assign or remove instances and services, you . You can only edit one user at a time.(explain more)
4. In On the Finish screen check your settings, to make changes click Back to continue click Finish.

Remove Users

To remove permission levels from users open the Manage Users instance permissions from a user follow these steps:

1. On the Administration tab go to Application security.
2. On the Manage Users window, select a user from the list and click Remove User.
3. Click Ok. 

Note
When you remove a user you only remove their custom permissions for IDERA SQL BI. Users still
Info
Removing users only deletes their product restrictions, they remain as Product Users and still have read-only access to all managed instances.

 

 

SQL  Business Intelligence Manager   identifies issues within the SQL BI environment to help optimize BI service performance.  Learn more   >>

...