Re: Permission problems user can't create a table

Hi,

Thanks for the info, just trying to get my head round this. The CREATE
TABLE permisson doesnt give the user permisson to create the table
unless they have permisson on the schema as well ?

If for example i had three schema's

Sales
Accounting
Marketing

How would I create a user that could create a table in all three
schemas and also a user that could just create tables in Sales and
Accounting but not Marketing.

On last question how can i view a users or database role permissions
through Management Studio, if for example i click on the public
database role , nothing shows up

Thanks again for all your help
Fran


.