Siebel: Create user in Sample Db

Creating User in Siebel through dbisqlc.exe in Sample dbf

1. Open dbisqlc.exe, then write and execute these below SQL statements

a) IF NOT EXISTS (SELECT NAME FROM SYSUSERS WHERE NAME= 'NEWUSER')execute sp_adduser NEWUSER

b) GRANT CONNECT To "NEWUSER" IDENTIFIED BY "NEWUSER"

c) sp_changegroup SSE_ROLE, NEWUSER




2. Enter in the Siebel application using userid/pwd SADMIN/SADMIN and create one employee "NEWUSER"

3. Give some responsibility to the employee "NEWUSER"

4. Give some position to this employee "NEWUSER".

5. Try to login using "NEWUSER/NEWUSER" to the sample db.