Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
Feedback

Database Schema


Overview

It is possible to define database schemas in Jet Data Manager. This is useful when users are accessing the data warehouse and you want to limit the number of tables the users see since only the Valid tables are relevant for reporting users.

 

Process

 

Setting up a Schema at the Datasource level

(this feature is available in JDM 2017 and higher)

 

Right-click the datasource for which you want to define a schema, and click Data source Settings...

 ds_schema1.png

 

This will display the available schema window:

ds_schema2.png

From here, you can select the schema you wish to work with. 

 

Setting up a Schema for Valid tables

(this feature is available on all versions of the JDM)

To define a schema at the table level, expand to the database you want to work with, right-click on Database Schemas, and select Add Database Schema

 

    1. Add a database schema


    2. Give the schema a name


    3. Apply the schema to valid tables


    4. Deploy and execute the project

 

Once the schema has been created you should make sure the database administrator or the person responsible for maintaining users on the SQL Server is told to give any report users access to the above schema alone.

 

Granting a user access to a schema

GRANT SELECT ON SCHEMA :: [SchemaName] TO [UserName]

 

 

 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments