Using the Grant Views Database Tool

Granting standard views

The Grant standard views window has two buttons. One option is to grant access to OSM standard views and the other options is to revoke access from the same views. Access can be given to, or removed from, specific database users.

The window consist of two lists.

• The left list contains database users that have been created in the OSM Database.

• The right list contains the views that are accessible to database user cow_read.

Access to views

The database user that is granted access, must prefix the views with cow_read in SQL commands to get access to the data.

Example

This command is correct.

SELECT * FROM cow_read.v_workpermit WHERE workpermit_assetcode = 'AN ASSET CODE'

/

This command is not correct.

SELECT * FROM v_workpermit WHERE workpermit_assetcode = 'AN ASSET CODE'

/

Grant button

It is possible to grant access to either one view, or to several views, or to all views.

Grant access to specific views

1. Select which database user should be given access.

2. Select which views the database user should have access to.

   

If more than one view is to be selected, then use the ctrl-key or the shift-key in combination with the mouse click.

Grant access to all views

3. If all views are to be selected then either:

   • Select the first view (at the top) and hold the mouse button down.

   • Drag the mouse to the bottom of the list. All views will be selected.

   OR

   • Select the first view (at the top). Scroll the list to the bottom.

   • Select the last view while using the shift-key. All views will be selected.

4. Click the Grant button.

Revoke button

It is possible to revoke the access to all views from a database user.

5. Select which database user that should have the access revoked. It is not necessary to select any views.

6. Click the Revoke button.