Local Database - For Multiple Users

We had to show a demo to the Client, our server got some issues and was getting restarted every now and then. We had only one environment set up at that time. We needed something if Server will not be up then how can we show demo to the client. The option was Local Database. We needed something like what we can do with the sample database where multiple users can login into the application using same database.

In our application, we were using Position and Organization based visibility for the Cases. Call Center user creates a record and assign it to an Organization and Position. Then the users who have that position has to work on that case. We needed to show the functionality where multiple users can login into the application.

How we can create multiple users login into Local Database. One of co-author of this blog and my friend Nikhil found something. On behalf of him, I am writing down steps to run some sql commands and multiple users can login into Local databases.

1. Open the dbisqlc with User ID Siebel and password of the user with whose Id local was extracted.
2. Then in dbisqlc, Grant permissions for users to use the Siebel application.
3. Run SQL 'grant connect to SSE_ROLE'.
4. Run SQL 'grant connect to identified by '.
5. Run SQL 'grant group to SSE_ROLE'.
6. Run SQL 'grant membership in group SSE_ROLE to '.

 NOTES:

• The must already exist in the database and the must be SSE_ROLE.
• The and in the grant command must be in UPPERCASE

Now you can grant multiple users the access to the Database. 

Sharing is the power.

Case sensitive and Insensitive Query

Siebel earlier used to have one Field Level Property Use Default Senstivity. This property is obsolete now.

To provide Case Insensitive Query on the Fields, Siebel 8.1 version has introduced a CIAI (Case and Accent Insensitive). Accent Insensitive does not work in Siebel 8.1.1.2 vesrion. You can use SoundsLike Operator for the Accent based query.
On the column level, right click at Column.

Siebel will run you through a wizard and create a new column and indexes to support the Case Insensitive Query.

Note: You need to lock the project to run through the wizard.

Export Data using dbisql.exe

Recently I found that there is one more way apart from using #getuid.out
which I post in my previous blog 'Query Result to file using dbisqlc'

select name from SYSUSERAUTH
where name not in ('SYS','DBA','PUBLIC','SIEBEL','DBO','dbo','SSE_ROLE') >#getuid.out

The other way to export the date into other file format is using output command.

After you execute your query.
You need to execute command having syntax

output to filename

output format can be in excel.

Sharing is the power

Query Result to file using dbisqlc

Hello Friends,

Most of us know that the Siebel has given us utility to query in the local database using dbisqlc.exe exist in Client/BIN folder or Tools/Bin folder.

To connect to Server, we generally use Toad or SQL Developer which provides us option to save the output in excel file.

The database siebel uses for Local is into Sybase. In the utility dbisqlc.exe , we dont have any option to save the result in any file. In Sybase, we have an operator '>' which can be used to direct output to a file.

For example the below query,

select name from SYSUSERAUTH
where name not in ('SYS','DBA','PUBLIC','SIEBEL','DBO','dbo','SSE_ROLE') >#getuid.out.

The output of this query will store login id in getuid file at the any of the following paths:
..\Tools\LOCAL\getuid
..\Client\LOCAL\getuid

Open the file & you can see your login id.

Sharing is the Power