Skip to main content
Planview Customer Success Center

Access control issue with custom stored procedures

We have created some custom stored procedures and granted access to CPACCESS. But we still run into access control problems. What could be the cause?


Verify the schema your object belongs to. If you created the object while being logged in as "cpadmin", the object might be in schema 'cpdep' rather than 'dbo'. To transfer the object to the right schema, use this SQL:

ALTER SCHEMA dbo TRANSFER cpdep.YourCustomSpName

Or drop your object and recreate it logged in as sa who normally has dbo as default schem