How to know the actual schema used for the SI?

Posted By Ricardo Silva over 6 years ago

Hi all,

Anyone knows how I can determine which database schema It's a customer currently connected within SI?

I can easily know the database connection details but I would like to know which schema I'm connected too?

I can determine this from the prompt parameters when running a report from the report manager but I would like to know if there is another place to check it?

Thanks.

Ricardo Silva

0 Ricardo Silva over 6 years ago

Thank you Jax.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 1116830 over 6 years ago

Hi Ricardo

The other way to do this would be to login to the Server(SQL) and check which Database schema the user has access to
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Colin Albert over 6 years ago

In SI for X3, the X3 folder you connect to is determined by the default schema for the SQL login you enter when you launch SI.

To change to a different schema, you need to logout of SI and reconnect using a login for the other schema.

If a site has two X3 folders, then you will need to create separate SQL users for each folder, with the relevant default schema for each folder.

This is done using the "SQL User Creation Tool" installed with SI or can be .done directy in SQL Server Management Studio.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage X3

How to know the actual schema used for the SI?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING