Security Administrator Reference

The Security Administrator defines Oracle users/roles with customized access rights on an enterprise industry model.

Note: To use the Security Administrator, you must have DBA rights. You must be familiar with Oracle and the enterprise industry model.

Main industry model—Industry Model (Oracle schema) that contains your data.

Guest industry model—Industry Model that accesses the main industry model by a role. You can create different roles to provide different levels of access to the main industry model. A guest industry model does not have any data tables, but only synonyms and privileges on the main industry model.

Guest user—an Oracle user created with Security Administrator with the role TBR_guest, which defines the relation between the main industry model and the guest industry model.

The role TBR_<guest> has specific rights on your main industry model, for example restricted access to some or all feature classes.

Note: You must manually maintain each role associated with the main industry model. For example, when you introduce new tables to your main industry model, for example by adding a new feature class, domain, topology, utility, extension, or intersection, or by running a data structure update, you must adjust the settings for each new table using the Security Administrator.

In the main industry model, use the SQL Sheet to query the privileges on that user.

select * from user_tab_privs; 
select * from user_tab_privs_made; 
Select * from user_tab_privs_recd;

Note: A guest industry model is based on a role on the main industry model. Therefore you cannot edit the industry model related settings. To edit the industry model related settings, open a project containing the main industry model.