Hi John,

Thanks for you reply,

Last question, is there any way that we can not select Public database role with the specific user. I have already created another database role...

Hi John,

Thanks fo replying,

in Public database role, they have access all content of database, Like SP, tables and view,

Could be change this Public database role setting for one...

Hi Jason,

Could you please help me on my one problme in Sql server 2005.

I have 1 database in sqlserver 2005. i want to give permission to the user to...