Remote Automation Solutions Guide: Security Group Privileges Reference Guide-OpenEnterprise v2.83 Manuals & Guides

Reference Guide

D301531X412
April 2012

OpenEnterprise Security Group
Privileges Reference Guide (V2.83)

Remote Automation Solutions

Website: www.EmersonProcess.com/Remote

Reference Guide

D301531X412
APRIL 2012

Security Group Privileges

Contents

1 Security Group Privileges Editor...........................................................................................1

1.1 Security Group Privileges Overview ...................................................................................1

1.2 Main Dialog .........................................................................................................................1

1.2.1 Table and View Groups................................................................................................2

1.2.2 Tables and Views.........................................................................................................2

1.2.3 Assigning Privileges .....................................................................................................2

1.2.4 Changed Privileges ......................................................................................................3

1.2.5 User Groups .................................................................................................................3

1.2.6 Creating User Groups...................................................................................................3

1.2.6.1 Administrators ........................................................................................................3

1.2.6.2 Engineers...............................................................................................................3

1.2.6.3 Operators ...............................................................................................................3

1.2.6.4 Dispatchers ............................................................................................................4

1.2.6.5 Guests....................................................................................................................4

1.2.7 OK.................................................................................................................................4

1.2.8 Cancel...........................................................................................................................4

1.2.9 Apply.............................................................................................................................4

1.2.10 Refresh......................................................................................................................4

1.2.11 Undo..........................................................................................................................4

1.2.12 Help...........................................................................................................................4

1.3 Main Dialog Menu...............................................................................................................4

1.3.1 File................................................................................................................................5

1.3.2 Edit................................................................................................................................5

1.3.3 View..............................................................................................................................5

1.3.4 Security.........................................................................................................................5

1.3.5 Tools.............................................................................................................................5

1.3.6 Help Menu ....................................................................................................................6

1.4 SQL Batches Dialog............................................................................................................6

1.4.1 Toggle Batch Operation................................................................................................6

1.4.2 SQL Batch Size ............................................................................................................6

1.4.3 Delay Between Batches ...............................................................................................6

1.4.4 OK.................................................................................................................................7

1.4.5 Cancel...........................................................................................................................7

1.4.6 Help ..............................................................................................................................7

1.5 SQL Execution Dialog.........................................................................................................7

1.5.1 Batch Processing Pane................................................................................................7

1.5.2 Batch Progress Bar ......................................................................................................8

1.5.3 Cancel - Close..............................................................................................................8

1.5.4 SQL Errors....................................................................................................................8

2 Index .......................................................................................................................................10

- i -

Reference Guide

D301531X412
APRIL 2012

Security Group Privileges

1 Security Group Privileges Editor

1.1 Security Group Privileges Overview

The Security Group Privileges Editor enables Administrative users to set table or view privileges for
User Groups.

Table and View privileges consist of: -

1. None - users who belong to the Group cannot view or change any of the data in the table or
view

2. RO (Read-Only) - users who belong to the Group can view the data in the table or view, but
cannot change it.

3. RW (Read-Write) - users who belong to the Group can view and change the data within the
table or view. This includes modification, insertion and deletion of objects.

Once table and view privileges are set up for each User Group, it is a simple matter of assigning each
user to the appropriate Group, and the user gets the database privileges required to do their job.

It is important to remember that only views contain access area security, such that a user can only
view objects within a table that belong to the access areas assigned to them. Giving a user RW or RO
privileges on the corresponding table will give the user access to all objects within the table.

Main Page

1.2 Main Dialog

The Security Group Privileges Editor enables Administrative users to set table or view privileges for
User Groups. The Main Dialog is a grid of table groups (vertical) and user groups (horizontal). Table s
and views are grouped into functional areas for greater clarity. Click the hotspots* on the example
below for further help.

- 1 -

Reference Guide

D301531X412
APRIL 2012

Security Group Privileges

SQL Batches Page
Security Group Privileges Overview

1.2.1 Table and View Groups

In order to avoid confusion, the more important tables and views have been group together according
to functionality. Each group is coloured grey, and has a plus sign to the left of it when not expanded -

.

When the plus sign is selected, the group expands to reveal the tables and views beneath it. The plus
sign then becomes a minus sign -

to indicate that the Group is expanded.

1.2.2 Tables and Views

Tables and views are displayed with a light blue background. They are grouped according to
functionality, and are slightly inset from the table and view groups under which they reside. They have
no minus or plus sign to the left of them, since they cannot be expanded themselves.

Tables can be largely identified by the presence of an underline in the name (i.e. realanalog_table,
dvi_device). Views have no underline (i.e. realanalog), except for the users table. It is important to
grant privileges on the views only for non-administrative users, since the views contain the
accessarea security that restri cts the viewing of objects according to accessarea.

1.2.3 Assigning Privileges

When you select a cell that defines a privilege for a User group, a drop-down list will appear.

- 2 -