...
| Note |
|---|
If you create objects that are finance-related, and if you have multiple finance schemas, object permissions should be promulgated across all finance schemas. |
...
Objects referenced in Crystal Reports run via Community Portal
If any object is required in a report accessible by via Community Portal, explicit permission are required depending on the schema.
If you are referencing any existing database objects in the Community Portal, these may need to have permissions granted similarly to user objects.
| Code Block | ||||
|---|---|---|---|---|
| ||||
GRANT SELECT ON [schema].[object] TO [Synergetic_CommunityPortalReports_{schema}_ReservedDBRole] |
...
The same will apply with granting execute permissions to any stored procedures that are used.
Existing objects referenced in Crystal Reports run via Community Portal
If you are referencing any existing database objects in the Community Portal, these may need to have permissions granted similarly to user objects.
| Note |
|---|
Media schema objects should be granted permissions to the dbo role [Synergetic_CommunityPortalReports_dbo_ReservedDBRole] |
...