![[ Informix Logo ]](/_borders/inflogo1.gif){kind=small}
|
Архив интересных статей по Informix |
| [ Пред. по дате ] [ След. по дате ] [ Пред. по нити ] [ След. по нити ][ Индекс по датам ][ Индекс по нитям ] |
| From | "Shulzhenko Vasyl" <vasilis@softline.kiev.ua> |
| Date | Mon, 1 Feb 1999 20:37:24 +0200 |
Let's take a test drive of DB Privileges. Start DB Privileges and when prompted, enter the name of the database 'stores'. Any users that may have been added through Informix SQL will be recognized, with their existing privileges, at this point. This check is done each time you start the program. You will never need to add users the hard way again. The Main Menu now displays with six options: Users, Groups, Public, Tables, Reports, and Databases.
Select Users from the Main Menu. This function allows you to query existing users, add, or update users, and set table privileges. The following is the User Privileges screen. The privileges for the user whose login is 'george' are being updated. George has select, update, and insert permissions on all the tables in the stores database. By changing any 'Y' to an 'N', a database administrator can revoke a table privilege from a user.
Update User
Update data and press ESC to save or DEL to abort
--------------------------------------------------------------------------
DB[stores ] DB Privileges REL:2.0
--------------------------------------------------------------------------
User Login: [george ] User Name: [George Jones ]
Group Name: [ ] Description: [ ]
Database Access: [C][CONNECT ]
--------------------------------------------------------------------------
Table Grantor Select Update Insert Delete Index Alter
------------------ -------- ------ ------ ------ ------ ------ ------
[adjustments ] [lester ] [Y] [Y] [Y] [Y] [N] [N]
[company ] [lester ] [Y] [Y] [Y] [Y] [N] [N]
[company_notes ] [lester ] [Y] [Y] [Y] [Y] [N] [N]
[contacts ] [lester ] [Y] [Y] [Y] [Y] [N] [N]
[deliveries ] [lester ] [Y] [Y] [Y] [Y] [N] [N]
[inventory ] [lester ] [Y] [Y] [Y] [Y] [N] [N]
[invoices ] [lester ] [Y] [Y] [Y] [Y] [N] [N]
[items ] [lester ] [Y] [Y] [Y] [Y] [N] [N]
[orders ] [lester ] [Y] [Y] [Y] [Y] [N] [N]
[payments ] [lester ] [Y] [Y] [Y] [Y] [N] [N]
--------------------------------------------------------------------------
Enter database privilege (D)BA, (R)ESOURCE, or (C)ONNECT
The bottom portion of the screen functions as a scrolling array and can contain many more tables than are displayed here. DB Privileges is designed to manage large databases. Now we will return to the Main Menu and select the Group function.
The Group function provides a way to create groups and define a set of table privileges for a group. Then, by assigning users to a group, they inherit the group's privileges and their database and table privileges are automatically updated. Users are not required to belong to a group, but managing large numbers of users with common permissions is simplified by using groups. You can create a data entry group, a billing group, a sales group, or any other logical grouping of people that fits your organizational needs.
The following is the Group Privileges screen updating the members of a group:
GROUP MENU: Query Next Previous Add Update Tables Members Exit
Update members of this group
--------------------------------------------------------------------------
DB[stores ] DB Privileges REL:2.0
--------------------------------------------------------------------------
Group Name: [sales ] Description: [Sales Division ]
Database Access: [C][Connect ] +---------------------------+
|Update Group Members |
--------------------------------------------| |
Table Grantor Select Updat|User Name Description |
------------------ -------- ------ -----|--------- -----------------|
[adjustments ] [lester ] [Y] [N] |andrew ] [Andrew ]|
[company ] [lester ] [Y] [Y] |bill ] [Bill ]|
[company_notes ] [lester ] [Y] [Y] |carol ] [Carol ]|
[contacts ] [lester ] [Y] [Y] |ed ] [Edward ]|
[deliveries ] [lester ] [Y] [Y] |janet ] [Janet ]|
[inventory ] [lester ] [Y] [N] |joe ] [Joe J ]|
[invoices ] [lester ] [Y] [N] |john ] [John J ]|
[items ] [lester ] [Y] [N] |list ] [List ]|
[orders ] [lester ] [Y] [Y] |rob ] [Robert ]|
[payments ] [lester ] [Y] [N] |tom ] [Tom ]|
--------------------------------------------|Enter the User's description|
+----------------------------+
122 Users in this Group
The Group function allows you to query groups, add or update groups, and set table privileges. One other function on the Group screen is Members where you can add, update, and delete users who belong to the group. For example, let's say you need to add a new salesperson to your database - you would select the Query command from the Group menu, enter the group name 'sales' in the group name field, and press the Esc key. This selects and displays the current information about the sales group. Select the Members function from the menu and enter the login name of the new salesperson with an optional description. Press F10 and the new user is added with the privileges assigned to members of the sales group.
Two additional views of privileges are available. One screen shows public database access and another displays, by table, all users that can access that table.
DB Privileges requires INFORMIX-4GL or RDS. DB Privileges works with Informix database servers 5.1 to 7.X, OnLine or SE. A runtime RDS version of DB Privileges is available for sites without Informix 4GL.
For more information or to order DB Privileges please call or contact:
| [ Home ] | Сайт создан при поддержке Украинского представительства Informix Software Inc. | Hosted by ANTEC |