Did you ever wonder what access rights are given in your database. If you want to control this manually this can take forever. In order to stay in the driverseat it is of course wise to grant access based on user groups. But when your database grows, it becomes more difficult on checking which user groups have what access to which part of the database. I have created a simple report that runs on a database, that provides the RWD access to the groups in your database in an excel output. Just import the script and the attached excel template into a report category. That should do the trick. Hope this might help some of you.
Good luck in staying in control.
Edwin
Hello
Yes that helps a lot. For instance, I am preparing a base migration from one platform to another and I wanted to give only read rigths to the source in order to avoid any modification. And identitying where I had to change write rigths to read only was not so easy. It is now !
The report gets nearly 16000 rows
Regards
