Skip to Content
0

Not able to see the Schema name created using SLT?

Jan 11, 2017 at 04:31 AM

79

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Raj K
Jan 13, 2017 at 05:19 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Bhaskar kumar Jan 18, 2017 at 09:15 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Sharadha K Jan 18, 2017 at 02:51 PM
0

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;

Share
10 |10000 characters needed characters left characters exceeded
Bhaskar kumar Jan 19, 2017 at 04:36 AM
0

Thanks Sharadha,

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

Share
10 |10000 characters needed characters left characters exceeded