Database location of Access Rights
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-03-19 02:15 AM
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?
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-04-19 10:01 PM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-04-19 02:00 AM
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
