myDBR maintains the report access rights based on the assigned rights. An access right for the report can be set for an individual user, for all users, or for a group maintained inside myDBR. A report can also be set to be accessible without the need to log in.
Access rights are determined under a report's 'edit' link.
Anyone how knows the report's direct URL can view the report. Login is not required. For more details see direct URL
In myDBR preferences, you can maintain a set of groups and assign individual users to these groups. These groups are static in terms of the users who belong to the group.
myDBR keeps track of 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 the automatic parameter "inLogin varchar(128)" to the report and myDBR will fill it automatically to contain the user's username.
The variable name (inLogin) is defined in defaults.php if you wish to change it.
The following report outputs the user's login name. No parameters are asked when the user runs the report.
create procedure sp_DBR_WhoAmI( inLogin varchar(128) ) begin select 'User running the report is: ', inLogin; end