george sibbald (1/21/2014)
it will have whatever rights are granted to public, we can only surmise that is all the app requires.as Erland says you a likely going to have to tweak the script anyway to make it work. Creating an unnecessary schema would be a slight performance hit whenever this ID accessed a database.
what is the alternative way to replace sp_adduser to add a user without adding the schema in the EXECUTE sp_MSforeachdb?
Thanks