Hello All,

I was trying to get the role infomation from outside database(our Remedy working with db_link). I got
the roles creating a SQLMENU.

my problem is:

We have a unified ticketing system that works for different types of tickets authenticating login name and check
role from outside database.

My roles like: A
B

User may have one role or multiple roles, when user clicks on the ticket it has to makesure that is right ticket
based on user role(s).

If user has single role, it is working good.
if user have multiple roles, i getting stuck here.

when i create a AL, it is working only using first role which is in the list.

Can anyone explain me how it works if user has multiple roles.

Appreciate your help....

Thanks
Mani

Hi,

You can use one of the followings solutions :
* Use the rwo level access to filter the tickets depending of the user roles.
* Use permissions based on a dynamic group to allow write on tickets depending of user roles.
* Use a guide do loop on role table in your active link workflow.

Thanks for your reply vincent,

I am newbie to remedy, can you please explain me in detail, if you can possible..

Regards,
Mani

Hi,

I had just present to you some methods you can use, but I don't have enough details to give you more details...

Could you add more details about what is in place and what you want to do?

Vincent,


I have users and they have some Roles stored in external databse.

I am trying to retrieve the roles authenticating login name in that external table.

I am getting those roles creating a SQLMENU(it is not working now). But one problem here, if user have

multiple roles(in the menu), how do i authenticate them all roles(i can authenticate if user have one role)



Let me explain you in detail:

i can view all tickets creating table field in control panel(display only form), those tickets are different
tickets based on the role.

when user click on the particular ticket, the user need to be authenticated using external database
which the roles stored in.

Is there any way to do using menu's(is that make sence).


My environment is

ARS 7.0.0
Sun Solaris 5.10
Oracle 10g.

Regards,
Mani

In your case you have some possibilities :
* Duplicate the user roles in the AR System Database in the Group form. Give to the users the right groups depending up to your external source. Applying roles on tickets as permissions on fields, workflows and records.
* Use a table field based on the external source (not a menu). Walk thru this table field by workflow to authenticate all user's roles. And give some access or restictions on tickets.