You could try executing the folowing SQL:
SELECT a.NAME,
CASE
WHEN b.groupid < 0
THEN 'Role ID ' || b.groupid
ELSE c.groupname
END groupname,
DECODE (b.permission, 1, 'Visible', 2, 'Hidden') permission
FROM arschema a, schema_group_ids b, group_cache c
WHERE a.schemaid = b.schemaid AND b.groupid = c.groupid(+)
ORDER BY a.NAME, b.groupid
The first column is the name of the form.
The second column is either the name of the group, or the Role ID of the Role
assigned to the form within a deployable application. When this is null, then
the
GroupID specified no longer exists on the AR Server.
The third column shows if the group or role has Visible access or Hidden access.
HTH
Chris.
> Hi,
>
> I am not sure how many forms are we talking here. May be environment
> information (including any OOB application) would have helped.
>
> Anyway, try this (it might be a tedious process):
>
> - you can export all the forms that you are referring
> - From the def file, you can decode the permissions at each form (including
> at each view level)
>
> Hope this helps
>
> Srinivas
>
>
> On 2/14/07, Remedy User <[EMAIL PROTECTED]> wrote:
>>
>> Hi All,
>>
>> I am new to Remedy. I just wanted to know if there are any ways to find
>> out the permissions given on all the forms available.
>>
>> Thanks in Advance.
>>
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
>> the Answers Are"
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
> Answers
> Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
