This can be done via Studio or pgAdmin III
Select the username parameter and enter the name of the user you wish to create by typing in the Edit parameter 'username' box. Repeat for the password and makeadmin (which should be false) parameters e.g.
Ensure makeadmin is false. |
Provide the following SQL as the cmdtoexecute parameter and run the task, changing the <user name> as required:
grant connect on database sdw to <user_name>; |
Type the following command in the query pane changing the <user name> & <password> as required::
SELECT astun.sdw_new_user('<user name>','<password>',false); |
e.g.
grant connect on database sdw to <user_name>; |