Report access rights

myDBR maintains the report access rights based on the assigned rights. An access right for the report can be set to an individual user, to all or to a group maintained inside myDBR. Also, a report can be set accessible as without the need to login.

Access rights are determined under a report's 'edit' link.

All logged in users

Every user who is logged in can run the report.

Access without login allowed via direct URL

Anyone how knows the report's direct URL can view the report. Login is not required. For more details see direct URL

Individual users

Individual users are the users in the particular database.

Groups inside myDBR

In myDBR preferences one can maintain a set of groups and assign Individual users to the group. These groups are static groups in terms of users who belong to the group.

Identifying the user running the report

myDBR keeps track with which username/password each connection was made to the database. If you need to know who is the user executing the report, you can add special parameter "inLogin varchar(30)" to the report and myDBR will fill it automatically to contain users username.

Variable name (inLogin) is defined in defaults.php if you wish to change it.

Following report outputs user's login name. No parameters is asked when user runs the report.

create procedure sp_DBR_WhoAmI( inLogin varchar(30) )
begin

select 'User running the report is: ', inLogin;

end

Showing report privileges at one glance

Adding &priv=1 to the url in main view lists the report privileges at one glance.

https://localhost/mydbr/index.php?m=1&priv=1