SQL Error Creating Table to Verify Previleges

Hi Friends,

During development when you are connected to your Local Database, you might need to test out any schema changes to a Table or Column.
In order to achieve this, you will be needing to apply the logical changes from Tools to your Local Database.

While doing so, you need to give Privileged Database User & Password to make changes to your Local DB Schema.
If you use your Tools login username & password; you would be greeted with this two errors:

First Error:
SQL Error Creating table Dummy Table to Verify Privileges


Second Error:
42000 (-121): [Siebel Database][ODBC Driver][Adaptive Server Anywhere]Permission denied: you do not have permission to use the "CREATE TABLE" statement


To avoid above errors, you need to change the Privileged User & Password being supplied before applying the change:

Siebel Application User Id User Password
Prior to Version 7.7 DBA SQL
Version 7.7 SIEBEL Local
Version 8.0 SIEBEL Local

Here, Local means to use your own Local User Password.
i.e. Say if you use dummyuser/dummypassword to login to your Local Tools, then you need to use SIEBEL/dummypassword as your Privileged User Id & Privileged User Password for making schema changes to your Local DB.

Siebel Bookshelf search engine

There is no need to keep bookshelf on your system and open PDF files everytime you want to search something from bookshelf.

Just bookmark the links provided below and you will be able to serach bookshelf anytime right from your browser window

Siebel Bookshelf 6.x (Siebel 2000)

Siebel Bookshelf 7.0x

Siebel Bookshelf 7.5 x

Siebel Bookshelf 7.7 x

Siebel Bookshelf 7.8 x

Siebel Bookshelf 8.0 x

Siebel Bookshelf 8.1 x


Happy Searching.............

How to Automate Login Into SIEBEL Tools and Dedicated client ?

Automating Login will save your time

Right Click the shortcut through which you acess the Siebel Client or Siebel Tools and choose Properties from the context menu.

• Scroll right to the end of Target Text Field Value enter the following text in the end.

/u sadmin /p sadmin /d sample

These text will automate your login to sample database. If you want to automate your login to Local Database enter the following code. 

/u username /p pwd /d Local

replace username with your local username and pwd with your local database password


Now you can login automatically everytime just with a mouse click