Re: jdbc permissions
From: s_m_b (smb20002ns_at_hotmail.com)
Date: 02/24/04
- Next message: rhj: "articel 816480"
- Previous message: Chinmay: "Re: Clustered columns confusion"
- In reply to: anonymous_at_discussions.microsoft.com: "jdbc permissions"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: jdbc permissions"
- Reply: anonymous_at_discussions.microsoft.com: "Re: jdbc permissions"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Feb 2004 04:14:03 -0800
<anonymous@discussions.microsoft.com> wrote in news:1493501c3fa41
$8cbdc0d0$a301280a@phx.gbl:
well, this is the page from the helpfile thats caused me to ask:
'''''''''''''''''
Using the SQL Server 2000 Driver for JDBC on a Java 2 Platform
-------------------------------------------------------------------------
-------
When using the SQL Server 2000 Driver for JDBC on a Java 2 Platform with
the standard security manager enabled, you must give the driver some
additional permissions. Refer to your Java 2 Platform documentation for
more information about the Java 2 Platform security model and
permissions.
You can run an application on a Java 2 Platform with the standard
security manager using:
"java -Djava.security.manager application_class_name"
where application_class_name is the class name of the application.
Web browser applets running in the Java 2 plug-in are always running in a
Java Virtual Machine with the standard security manager enabled. To
enable the necessary permissions, you must add them to the security
policy file of the Java 2 Platform. This security policy file can be
found in the jre/lib/security subdirectory of the Java 2 Platform
installation directory.
To use JDBC data sources, all code bases must have the following
permissions:
// permissions granted to all domains
grant {
// DataSource access
permission java.util.PropertyPermission "java.naming.*", "read,write";
// Adjust the server host specification for your environment
permission java.net.SocketPermission "*.microsoft.com:0-65535",
"connect";
};
To use insensitive scrollable cursors, and perform client-side sorting of
some DatabaseMetaData ResultSets, all code bases must have access to
temporary files. If access to temporary files is not available, the
driver may throw an exception indicating that it is unable to set up a
static cursor cache.
For JDK 1.1 environments, access to "current working directory" must be
granted.
For Java 2 environments, access to the temporary directory specified by
the VM configuration must be granted.
The following is an example of permissions being granted for the C:\TEMP
directory:
// permissions granted to all domains
grant {
// Permission to create and delete temporary files.
// Adjust the temporary directory for your environment.
permission java.io.FilePermission "C:\\TEMP\\-", "read,write,delete";
};
''''''''''''''''''''''''''''''''
> Make sure you give sql permissions to the sql user you are
> using in your servlet to connect to sql server. There is
> no concept of giving read/write permissions to a jdbc
> driver.
>
> Let us know if you need more clarification on this or how
> to do it.
>
via the tomcat log, its failing to load the jdbc driver, but whether its
authentication or unable to find the driver, I'm not sure
> hth.
>
>>-----Original Message-----
>>seems precious few answers in the jdbc group...
>>as I'm trying to connect Tomcat 5 to MSDE, according to
> the help system, I
>>have to give the jdbc driver some read/write perms, but
> as the java is
>>actually a servlet, there is no codebase being used.
>>Anyone got any ideas on where I can set the permissions?
>>.
>>
>
- Next message: rhj: "articel 816480"
- Previous message: Chinmay: "Re: Clustered columns confusion"
- In reply to: anonymous_at_discussions.microsoft.com: "jdbc permissions"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: jdbc permissions"
- Reply: anonymous_at_discussions.microsoft.com: "Re: jdbc permissions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
