Database Encryption

Поиск
Список
Период
Сортировка
Искать

Database Encryption

От:
"JR Richards" <jr@ebcrp.org>
Дата:
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

От:
Jonathan Gardner <jgardner@jonathangardner.net>
Дата:
-----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 
(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

От:
Ragnar Kjørstad <postgres@ragnark.vestdata.no>
Дата:
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.

От:
Stuart <deststar@blueyonder.co.uk>
Дата:
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

FAQ