Hi,

i run an asp.net application which uses sql server express.
i defined a login 'aspnet' (IIS 5.0) and for the specific database, an user
'aspnet' with following roles:
db_datareader and db_datawriter.

Now, any user who uses that application must also be able to create
programmatically tables in that database. My question is: which role do i
have to give to user 'aspnet'?

Thanks
Dan

Hi Dan

"Dan" wrote:

> Hi,
>
> i run an asp.net application which uses sql server express.
> i defined a login 'aspnet' (IIS 5.0) and for the specific database, an user
> 'aspnet' with following roles:
> db_datareader and db_datawriter.
>
> Now, any user who uses that application must also be able to create
> programmatically tables in that database. My question is: which role do i
> have to give to user 'aspnet'?
>
> Thanks
> Dan
>
Rather than granting permissions to general database roles you should be
defining your own roles with the minimum privileges necessary to do the task
preferably using stored procedures.

CREATE TABLE permission in the database will be required to create the table
along with ALTER permission on the schema in which the table is being created.

Other permissions may be neeced if you reference a CLR or XML data type.
This is documented in Books Online under the CREATE TABLE information.

John

Thanks,


"John Bell" <jbellnewsposts@hotmail.com> schreef in bericht
news:740F9CE8-E0A5-4922-9FB8-12460340E425@microsoft.com...
> Hi Dan
>
> "Dan" wrote:
>
>> Hi,
>>
>> i run an asp.net application which uses sql server express.
>> i defined a login 'aspnet' (IIS 5.0) and for the specific database, an
>> user
>> 'aspnet' with following roles:
>> db_datareader and db_datawriter.
>>
>> Now, any user who uses that application must also be able to create
>> programmatically tables in that database. My question is: which role do i
>> have to give to user 'aspnet'?
>>
>> Thanks
>> Dan
>>
> Rather than granting permissions to general database roles you should be
> defining your own roles with the minimum privileges necessary to do the
> task
> preferably using stored procedures.
>
> CREATE TABLE permission in the database will be required to create the
> table
> along with ALTER permission on the schema in which the table is being
> created.
>
> Other permissions may be neeced if you reference a CLR or XML data type.
> This is documented in Books Online under the CREATE TABLE information.
>
> John
>
>