Giving java application sufficient permission to create tables

Dear All
How is it possible to give a Java application sufficient permission to
create tables in SQL Server 2005?
Thanks
DanielDaniel Malek (DanielMalek@.discussions.microsoft.com) writes:
> How is it possible to give a Java application sufficient permission to
> create tables in SQL Server 2005?
You cannot give an application per se permission to do anything. The ways
to go in your case are:
o A stored procedure signed with a certificate, associated with a user
that has the privs.
o A stored procedure with EXECUTE AS.
o Use an application role.
o Authenticate users in the middle layer, and connect to SQL Server with
proxy login that has the required privs.
I discuss these methods in different levels of details on
http://www.sommarskog.se/grantperm.html.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx