Database location of Access Rights

[robin_wylie]

I'm having difficult finding the database tables/columns that contain the data used in the Access Rights feature of BP 6.3. Anyone know what tables to look at?

[BenKirimlidis]

Here ya go buddy ---- START OF MS SQL CODE use [XXXXXXX]; -- Replace this with the name of your DB go SELECT CP.ProcessId ,P.Name as ProcessName ,CP.CredentialId ,C.Name FROM [dbo].[BPACredentialsProcesses] as CP inner join [dbo].[BPAProcess] as P on P.ProcessId = CP.ProcessId inner join [dbo].[BPACredentials] as C on C.ID = CP.CredentialId ; ---- END OF MS SQL CODE

[BenKirimlidis]

That was some of the ugliest parsing i've ever seen.  Never copy SQL pasting into this again ---- START OF MS SQL CODE use [XXXXXXX]; -- Replace this with the name of your DB go SELECT                     CP.ProcessId                     ,P.Name as ProcessName                     ,CP.CredentialId                     ,C.Name FROM         [dbo].[BPACredentialsProcesses] as CP inner join     [dbo].[BPAProcess] as P on                P.ProcessId = CP.ProcessId inner join     [dbo].[BPACredentials] as C on                C.ID = CP.CredentialId ; ---- END OF MS SQL CODE