"Because the database will be handling different companies, with their own schema."

That is the wrong solution to the problem. Have one database for each company and each login has access to only one database.

Be sure to setup a separate ODBC name and DNS aliases for each company and so that if you decide to move one of the database to a different server, only the IP of the DNS alias needs to change.