Forgot password of old Siebel DBF file sse_data.dbf

If you have an old Siebel database and you have forgotten the user id and password you can execute below set of command on that dbf to get your user id created on the dbf. Please find the steps as below.

Steps:

1)      Copy the .dbf to Tools\LOCAL

2)      Launch dbisqlc.exe from tools\bin

UserName = DBA

Password = ENTRPRISENAME

Click On Database Tab -> Select Database File as the .dbf in the Tools\LOCAL

Click on OK

3)      Once connected run below mentioned command.

grant connect to SSE_ROLE

grant connect to USERNAME identified by PASSWORD

grant connect to SIEBEL identified by PASSWORD

grant group to SSE_ROLE

grant membership in group SSE_ROLE to USERNAME

Commit

NOTE: USERNAME & PASSWORD Need to be in CAPITAL CASE

4)      Make environment specific changes in your Tools.cfg and create a local DSN to connect the .dbf file