How Can Multiple Users be Created on a Siebel Local Database?.

Purpose

This procedure has been put together primarily for sales people or other users who want to demonstrate various features of a Siebel application running against a local database. This should never be done in a live production environment.

Scenario

When a local database has been extracted and multiple users are required to log on to this database for demonstration purposes.

 

Limitations

• The data in the local database is restricted to the user for which it was extracted.
• The local database cannot be synchronized against the server as the local database is accessed using different logins.
• If data is subsequently changed on the server, it will be necessary to do another database extract and local database initialization with re-executing the steps to create multiple users.
• If the newly created users receive a message that they do not have rights to access Home-Page view, reconnect to the Local Database using the original extracted user and recreate them in the User Administration screen. This is necessary because some records might be missing related to these users in the intersection tables and recreating the users would populate them.

Steps to create multiple users on a local database

1. Login to isql55 (for Siebel Application versions 7.x and 8.x use dbisqlc), which is located in the <Siebel Client>\bin directory. See Document 475652.1 for more information about logging into the local database.

To do this open a command prompt or DOS prompt and change directories to the <Siebel client>\bin directory. Then run one of the following commands:

isql55 -c UID=DBA;PWD=SQL;DBF=c:\<Siebel_client_root>\local\sse_data.dbf

isql55 /?      (This will display a list of parameters available.)

isql55            (This will bring up a query screen. Type a SQL statement and then click on the EXECUTE button; a prompt for username, password and database file appears.)

2. Grant permissions for users to use the Siebel application:

grant connect to SSE_ROLE

grant connect to <USER_ID> identified by <PASSWORD>

grant group to SSE_ROLE

grant membership in group SSE_ROLE to <USER_ID>

NOTES:

• The <USER_ID> must already exist in the database and the <group name> must be SSE_ROLE. 

• The <USER_ID> and <PASSWORD> in the grant command must be in UPPERCASE.