Question about SQL Server users on shared Godaddy hosting accounts

Question

I have a client who needs a report created using data retrieved from a SQL Server database on a shared Godaddy hosting account. I do not need full access to this database, so I have asked the hosting account owner (supposedly a web site developer) to create a user for me that has only select privileges on the tables I need access to.

However, the owner of the hosting account says that a Godaddy representative told him that they will not allow him to create a another database user unless he upgrades to dedicated hosting. He says that all he can provide me with is the one admin user that has been assigned to him and that he cannot create another user. Does anyone know if Godaddy really limits shared Windows hosting plans to one SQL Server admin user like this?

Answer 1

A user requires a login and shared hosting will not allow a new login AFAIK, logins being an instance level construct as opposed to a database level one. He can create an approle for you, but you still need his login to get in, so no much gain there.