Skip to main content

Can userid's be added to the XDB Server through an ini file?

  • February 15, 2013
  • 0 replies
  • 0 views

Problem:

Do I also need to add a DBA-like user to SQL Wizard on each subsequent workstation - and, if so, can I add this to an INI file somewhere rather than thru the GUI?

Resolution:

No, it has to be added as a create user statement because the information resides within a system location table (sysacfusers) on the XDB Server.

You can create a script to do it and add it to a batch process if you do not want to add through SQLWizard.  The script would be something like this for a super user of TEST with a password of TEST:

CREATE USER TEST

TYPE SUPERUSER

PASSWORD TEST REQUIRED YES

;

Old KB# 2570

#MFDS
#EnterpriseDeveloper