InterviewSolution
| 1. |
If the tables of a schema are implemented to create modeling views then why is it essential to grant SELECT privilege to user _SYS_REPO? |
|
Answer» If tables of a SCHEMA for example SCHEMA_ABC are implemented to create the modelling views, then the following SQL statement must be performed before starting any such modelling views. GRANT SELECT ON SCHEMA SCHEMA_ABC TO _SYS_REPO with the option of GRANT After all your models that access data in your schemas has been activated, _SYS_REPO wants to OFFER you and other users read access to the activated models. |
|