• Have a read of this: http://msdn.microsoft.com/en-us/library/ms189121.aspx

    So you can either go with the predefined database roles and choose the appropriate roles (db_datareader, db_datawriter, db_ddladmin) to the mapped users.

    Or

    Create a database role, grant the role the required permissions then add your users to the role.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn