For adding users to metadata server ("SMC"), see Intelligence Platform, security guide:
http://support.sas.com/documentation/cdl/en/bisecag/61133/HTML/default/a003175544.htm
In SAS 9.1, I think that profiles has to be created manually by the users. Maybe, if you have some shared accounts, you can copy the profile. Creation of individual profiles is not a standard task. Each profile is text file (with the text !!!!! DO NOT EDIT !!!!!!! in the header...). If you don't want to put the password in the file, yo try generate this file using a script, but I assume this is not supported by SAS.
In 9.2 the profiles has slightly changed, maybe it will help you. Haven't played around it enough to help you out there.
Regards,
Linus
Data never sleeps