SQL server user account

Hi Listers,
I have a MSSQL 2000 database on a hosting company server! they provided me one SQL username which has the Administrator permissions! I am publishing the database using XML forms (Access Data Pages) I was wondering how can I manage the application security having just one username! and let the usres (3 people) use the database online!

Any hint wound be helpful.

Thank you,

Robert A. Broomandan

Do you have SQL enterprise manager or something like that to create new accounts? The best thing would be to use your admin account to create another application account, which has select/insert/update/delete privileges on the tables that you need.

Let me know if you have a SQL Enterprise Manager and I can post instructions on how to set up a user and set permissions.

I do have ithe Enterprise Manager! the problem is my hosting company wont let me have more that one SQL Username! or account!

Well, if you're database system admin on the database, then you should be able to add your own logins and stuff. However, if you only have owner (db_owner) rights on a single database, then you cannot create new users -- you can create and drop tables on that single database though. It is a bad idea to use the same user that can create/drop tables to do reports and stuff though -- see if your hosting company can somehow create a separate user for you with db_datareader rights perhaps