Giving permissons to s single SQL database

[dross]

HI, I have a server running MS SQL and I have a few databases on it. These databases have been mine for testing and I access them by logging directly into the server. I have a new client that needs a database. I only want to give them access to this single database. What is the correct way to give someone permissions only to this single database?

Thanks
David

[aspdaddy]

Create a new login, make it dbo not public role, assign it to the database.

[dross]

Thanks, but when I click on the new users name under logons, and go to database Access, If I try to remove the check box from public, I get a message "members cannot be dropped from 'public'

Thanks

[aspdaddy]

sorry wrong way around I meant public not dbo :)

Is this a website database?, If so make sure you only grant select permissions to specifc views, and execute permission to specific stored procedures. Dont give them select on tables or anthing like that. Tell them you will create the daatbase objects for them from thier SQL script. Also dont give them port 1433 access, there are web based tools for accesing it more securly.