Hey everyone,
I’m looking into setting up individualized logins for our security application (currently we just use the SA login). In the Implementation Guide doc I came across a reference to a doc called “Security Administration” but I can’t find this doc or anything similar.
Does anyone know where I can find this doc or something similar? Or…how to set up individualized security application logins?
Thanks as always for any advice!
Natasha
I was recently doing this as well. :)
I hope the link works to the document. Setting up a security user login is right at the beginning. Fairly simple!
http://www.tessituranetwork.com/PDFs/Tessitura_Security_Application.pdf
Perfect, thanks Beth!
Hi Natasha,
Thought I'd append the following tip in case someone needs it later:
When adding your own security users, it is possible to run into trouble after doing a LIVE-to-TEST copy; the logins may not match the database users after you do your restore. This is mentioned in the MovingaDatabase.doc, but the procedure they recommend has been deprecated and may not work in the future. The code I use in my post-restore script is:
USE impresario GO ALTER USER userone WITH LOGIN = userone ALTER USER usertwo WITH LOGIN = usertwo GO USE impresario_cci GO ALTER USER userone WITH LOGIN = userone ALTER USER usertwo WITH LOGIN = usertwo GO
Good to know, thanks Nick.