Database User cleanup

CobaltSS

Hi all,

I'm going through the SQL database and removing all the "Database Login" accounts that are just sitting in there. We've switched recently to SQL authentication, and I'm doing this in our TEST server before trying to do it in our LIVE server. For the most part, if the SQL -> Database -> Security -> Users does not have domain in front of it, I'm deleting the account.

There are a few accounts I'm not sure I can delete though. Stuff like HOTCOPY and INFORMATION_SCHEMA. Are these intrinsic to NAV? Are there any others?

cheers,

kine

Hotcopy looks like account used to make backup (hotcopy) of the Native DB. The second one I do not know why is there...

bbrown

INFORMATION_SCHEMA is a built in user. It cannot be deleted