Power User prohibits procedure execution

真織 野口

hello

I want to limit the procedure execution of a user who has a Power User license.
Even if you turn on "Deny procedure editing" in the profile
the following situations cannot be avoided.
-> Procedures can be set with label actions
-> You can execute the procedure from the label in play mode.

I have a Power User create a screen.
I don't want you to execute a specific procedure.

Is there a solution?

Best regard

Davide Corbetta

Hi ,
There is not a direct, simply mode, but you can easy define a process for allow/deny procedure excecution from users.

• First you must have a entity dimension "user" linked to user security: (select user= @user) in database.
• create a cube "permission" with dimension user where you put 1 if whe user is allowed to execute procedure
• modify your procedure by testing if the value of permission is <>0. if not Exit procedure

You can use this way also for manage permission on all the procedures in your application.Hi ,

------------------------------
Davide Corbetta
Technical Director
ADVISON SRL
Italy
------------------------------
-------------------------------------------