Posted by Erland Sommarskog on 08/22/07 13:56

monty (manishgandhi13@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]