Posted by monty on 08/22/07 14:58

On Aug 22, 6:56 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> monty (manishgandh...@gmail.com) writes:
> > it's ok....but i just want to know....do we need to have DB_OWNER role
> > for executing DDL statements through OLEDB API ??
>
> DDL statements require at least membership in db_ddladmin, no matter how you
> connect.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

I am creating and using a temp table. For doing this db_ddladmin role
will be enough??

• Next in forum: Re: A floating point exception occurred in the user process
• Prev in forum: Re: Problem with DB_OWNER role..
• Thread view: Re: Problem with DB_OWNER role..

[Reply to this message]