Thread: Database Encryption

Database Encryption

From
"JR Richards"
Date:
I'm interested in using a passwords table with my Access front end, but
need to encrypt the passwords over the network.  Can anyone help me get
started on this kind of project?


Re: Database Encryption

From
Jonathan Gardner
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tuesday 17 June 2003 11:18, JR Richards wrote:
> I'm interested in using a passwords table with my Access front end, but
> need to encrypt the passwords over the network.  Can anyone help me get
> started on this kind of project?
>

Isn't ODBC what is being used between PostgreSQL and Access? I am not sure on
the details, but that is the place to start looking for an answer. If ODBC
can support secure SSL/TLS connections, then you can just use that to
connect.

If Access can't handle a secure connection, then you have no options but to
abandon Access.

- --
Jonathan Gardner <jgardner@jonathangardner.net>
(was jgardn@alumni.washington.edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+8cSgWgwF3QvpWNwRApg3AJ9VCLFOWmuxrfVS2DL8f8e1M2enWQCfSO+c
DoT/2UWQY1vJ1W2WP2Cmfc0=
=JfLg
-----END PGP SIGNATURE-----

Re: Database Encryption

From
Ragnar Kjørstad
Date:
On Tue, Jun 17, 2003 at 11:18:57AM -0700, JR Richards wrote:
> I'm interested in using a passwords table with my Access front end, but
> need to encrypt the passwords over the network.  Can anyone help me get
> started on this kind of project?

I would think that you could use ssh or stunnel to securely tunnel the
traffic.

Alternatively some kind of VPN would do.


--
Ragnar Kjørstad
Zet.no

Re: Login as different user inside of a function.

From
Stuart
Date:
Kris Kiger wrote:
> Here's my problem.  I have user X calling a database function.  The
> function inserts data into table Y.  User X only has select access to
> this table.  Is there some way to allow user X to call a function that
> does an insert for him/her without user X having to have write access to
> table Y?  Is it possible to log in as another user inside of a function?
> Thanks for the help!
>
> Kris

If you are using 7.3 or later you can create the function using SECURITY
DEFINER.
hth,
- Stuart