Not able to see the Schema name created using SLT?

[Former Member]

I have created the SLT configuration but i cant able to see the schema under the catalogue.

Secondly i cant able to preview the data for the table

[Former Member]

Thanks Sharadha,

I have executed the above mentioned queries earlier and the Schema is added under the object Privileges tab still issues Persists.

[Sharadha1]

Which user are you using to view the schema.

Login as SLT user which gets created when SLT configuration is done and provide access to _SYS_REPO user using GRANT statement

GRANT SELECT ON SCHEMA <YOUR_SCHEMA> TO _SYS_REPO WITH GRANT OPTION;

[Former Member]

Thanks Raj,

Once the SLT Configuration is done these roles are automatically created like Select, data_prov, super_user, Admin but after that also i cant able to see the Schema in my Catalog.

In our case all 5 roles are there but not able to see the Schema.

Please suggest and let me know know.

Thanks,

Bhaskar

[rindia]

After the SLT configuration is created, few roles are created and these roles have to be assigned to the user depending on the need.

Example:

Role ( <configuration_name>_SELECT ) will give select access to the user but cant replicate the tables.

Role ( <configuration_name>_DATE_PROV ) will allow to replicate the tables.