As of April 17, 2018, this site is now in read-only mode. To start new Blackbaud Developer’s discussions, you will find Developer Discussions in the Blackbaud CRM Community.
To post or respond to Blackbaud Community discussions, you will have to login using a www.blackbaud.com login. Learn how to login here. If you have questions or need assistance, please email firstname.lastname@example.org.
When I create a table using a table spec, permissions are not assigned to the new table. I am expecting the BBAPPFXSERVICEROLE to be granted rights to select from the table.
Currently, I use a post-deploy SQL script to assign rights. Is this the expected method to setup SQL database permissions?
I'm working with BBEC 2.9.
Description="Test table for permission demonstration."
Author="Blackbaud Professional Services"
<!-- define fields on the table -->
<TextField Name="COLUMN1" Length="20" Required="true"/>
<NumberField Name="COLUMN2" Type="int" DefaultValue="10" />
I believe what you are doing is correct. I have had to write lot's of grant select, insert, update, delete, etc. for the BBAPPFXSERVICEROLE on both oob and custom tables before while doing BBIS work. I know 2 or 3 other people are following the same practice.
If you are accessing these database objects from CLR data forms, business processes, etc. then you can grant them to BBAPPFXSERVICEROLE by using the <GrantExecuteList> element in any CLR catalog implementation element.
For example, correspondence business process grants rights to these objects.
If all of your select, insert, and update logic is wrapped by a stored procedure, there should be no need to grant rights to tables and columns.
However, in some cases, it's not practical to implement everything in a stored procedure or function. I those cases you can also include one of the other grant lists.
This applies to several features, not just business processes. You can define those grant list elements in any of these spec CLR implementations.
BBIS runs under whatever user the app pool is assigned to. Usually thats NT AUTHORITY\NETWORK SERVICE. You can either explicitly grant permissions to that user or (more reliably) grant them to BBAPPFXSERVICEROLE.
A SQL Script is the best way to do that. The only way around it would be to have BBIS running under a user that has the same access level as CRM, which would not be advisable.