Profile picture for user edwv

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

File attachments
by Jeffrey Gortmaker
Posted on Thu, 05/03/2012 - 13:38

Hi Edwin,

seems like a very useful report, but I can't get the report working.

I installed it in the category Administration:

But when selecting Evaluate > Start Report on the context database, It does not show.

What did I do wrong?

0
by Harry Ratia
Posted on Wed, 06/27/2012 - 16:05

Hi Jeffrey,

 

I noticed after having imported the report script that it is not made available to users. This is a property of the script that you will need to change, and then it should be able to show up.

 

I hope this helps.

 

Regards   / Harry R

0
by Jean Noel Gobet
Posted on Fri, 05/24/2013 - 08:19

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

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock