1 of 1 people found this helpful
There are two types security realm by default in JBoss EAP
- Management Realm
- Application Realm
The "web-ui", CLI and AdminShell requires a user that is created in the Management Relam. This is typically a "admin" type user. However, when you are issuing a SQL query through JDBC to Teiid, that requires a user created in the Application Realm.
Now, just because you created a "Admin1" user and created data source X, that will not be visible to "Admin2" or can be used "User1". It only means a user in the management realm will be able to change the configuration of the JBoss EAP instance. Where as user in Application realm will not be able to access the same using the web-ui.
As per the visibility of the services as to who has what visibility is whole another section in Teiid. It is called "Data Roles". Read this carefully (may be multiple times) Data Roles - Teiid 9.0 (draft) - Project Documentation Editor then ask any questions. There should be an example in quick starts too on this.