<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic That was some of the ugliest… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Database-location-of-Access-Rights/m-p/88865#M39347</link>
    <description>That was some of the ugliest parsing i've ever seen.&amp;nbsp; Never copy SQL pasting into this again
---- START OF MS SQL CODE
use [XXXXXXX]; -- Replace this with the name of your DB
go
SELECT
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; CP.ProcessId
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ,P.Name as ProcessName
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ,CP.CredentialId
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ,C.Name
FROM&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;[dbo].[BPACredentialsProcesses] as CP
inner join&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;[dbo].[BPAProcess] as P
on&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; P.ProcessId = CP.ProcessId
inner join&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;[dbo].[BPACredentials] as C
on&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;C.ID = CP.CredentialId
;
---- END OF MS SQL CODE</description>
    <pubDate>Fri, 05 Apr 2019 01:00:00 GMT</pubDate>
    <dc:creator>BenKirimlidis</dc:creator>
    <dc:date>2019-04-05T01:00:00Z</dc:date>
    <item>
      <title>Database location of Access Rights</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Database-location-of-Access-Rights/m-p/88863#M39345</link>
      <description>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?</description>
      <pubDate>Sat, 02 Mar 2019 02:15:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Database-location-of-Access-Rights/m-p/88863#M39345</guid>
      <dc:creator>robin_wylie</dc:creator>
      <dc:date>2019-03-02T02:15:00Z</dc:date>
    </item>
    <item>
      <title>Here ya go buddy
---- START…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Database-location-of-Access-Rights/m-p/88864#M39346</link>
      <description>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</description>
      <pubDate>Thu, 04 Apr 2019 21:01:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Database-location-of-Access-Rights/m-p/88864#M39346</guid>
      <dc:creator>BenKirimlidis</dc:creator>
      <dc:date>2019-04-04T21:01:00Z</dc:date>
    </item>
    <item>
      <title>That was some of the ugliest…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Database-location-of-Access-Rights/m-p/88865#M39347</link>
      <description>That was some of the ugliest parsing i've ever seen.&amp;nbsp; Never copy SQL pasting into this again
---- START OF MS SQL CODE
use [XXXXXXX]; -- Replace this with the name of your DB
go
SELECT
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; CP.ProcessId
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ,P.Name as ProcessName
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ,CP.CredentialId
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ,C.Name
FROM&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;[dbo].[BPACredentialsProcesses] as CP
inner join&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;[dbo].[BPAProcess] as P
on&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; P.ProcessId = CP.ProcessId
inner join&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;[dbo].[BPACredentials] as C
on&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;C.ID = CP.CredentialId
;
---- END OF MS SQL CODE</description>
      <pubDate>Fri, 05 Apr 2019 01:00:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Database-location-of-Access-Rights/m-p/88865#M39347</guid>
      <dc:creator>BenKirimlidis</dc:creator>
      <dc:date>2019-04-05T01:00:00Z</dc:date>
    </item>
  </channel>
</rss>

