Share
Report
25Hello there,
We are planning to create a view (in [ext] schema) of an existing table in [crt] schema in the channel database. While it works just fine with RSSU, it does create problems while deploying the RCSU changes. The deployment fails with the below error
Deployment has failed with the error message: 'There was an error when applying the channel database extension file '<filename.sql>'. The REFERENCES permission was denied on the object 'SCRUBBEDCUSTOMERPHONENUMBER', database '<database name>', schema 'crt'.
Cannot find the object "SCRUBBEDCUSTOMERPHONENUMBER" because it does not exist or you do not have permissions. Near statement:
CREATE VIEW [ext].[SCRUBBEDCUSTOMERPHONENUMBER_XYZ] WITH SCHEMABINDING
CREATE VIEW [ext].[SCRUBBEDCUSTOMERPHONENUMBER_XYZ] WITH SCHEMABINDING
AS
SELECT
--FIELDS SELECTION
FROM [crt].[SCRUBBEDCUSTOMERPHO... '
SCRUBBEDCUSTOMERPHONENUMBER is an existing table in the [crt] schema in the channel database. This works just fine with the RSSU deployment since we, as the user manage/own the channel db but no luck with RCSU.
We were also thinking of using the below command to provide the REFERENCES permission
GRANT REFERENCE ON OBJECT::[crt].[SCRUBBEDCUSTOMERPHONENUMBER] TO [UsersRole]
GO
GO
But not sure who to give the permission to. Could you please advise which user the RCSU deployment user belongs to? Highly appreciate any inputs to address this issue.
We use PU36 (10.0.12). Thanks!
All responses (
Answers (
