SQL to extract the Read and Modify privileges

Question

Home

Does anyone have a SQL to extract the complete details of all of the Read and Modify privileges ?

agileplmuser Agile User Asked on January 13, 2021 in Product Collaboration.

Add Comment

1 Answer(s)

To extract the privileges details you can use OOTB report ‘Privilege Mask Detail Report’ that is available in Administrator Reports

KGP Agile User Answered on January 24, 2021.

Add Comment

Answer 1

As noted by stevend17, AGILEOBJECTIDSEQUENCE was used to generate the ID for all tables in the database. For everything up...

Answer 2

Hoo boy, you aren't asking for much, are you?? I would venture that it cannot be done as "one query result"....

Answer 3

Based on a script I created years ago to correct sequence values after cloning from a production environment to a...

Answer 4

We may not share the same version of Agile, because I cannot find "Complaints" as a class. If indeed Complaints...

Answer 5

Svevis, I'm not certain I can help or not, but to even start I have some questions. What is the...

Answer 6

As noted by stevend17, AGILEOBJECTIDSEQUENCE was used to generate the ID for all tables in the database. For everything up...

Answer 7

Hoo boy, you aren't asking for much, are you?? I would venture that it cannot be done as "one query result"....

Answer 8

Based on a script I created years ago to correct sequence values after cloning from a production environment to a...

Answer 9

We may not share the same version of Agile, because I cannot find "Complaints" as a class. If indeed Complaints...

Answer 10

Svevis, I'm not certain I can help or not, but to even start I have some questions. What is the...