Skip to Content
avatar image
Former Member

Not able to see the Schema name created using SLT?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 13, 2017 at 05:19 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 18, 2017 at 09:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 18, 2017 at 02:51 PM

    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;

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 19, 2017 at 04:36 AM

    Thanks Sharadha,

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

    Add comment
    10|10000 characters needed characters exceeded