Tuesday, June 19, 2007

Creating Multiple users for Local Database

Log on to local db from command prompt

dbisql55 -c UID=DBA;PWD=SQL;DBF=c:\\local\sse_data.dbf

Create Users in local

grant connect to SSE_ROLE
grant connect to MADHAV identified by MADHAV
grant group to SSE_ROLE
grant membership in group SSE_ROLE to

Create Employee Record in Using Siebel UI for the user you have created with proper responsibility and position

*p.s. Password and User Id sud be upper case

No comments: