By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 1,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

Different users, different access using encrypted data

P: n/a
My database have 20 tables and many users. I wish to store encrypted
data in 3 tables and have only 3 users have access to them, walking
into tables or using forms.

Can someone point me a direct help or something to read?

Tnx
Nico
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Nico wrote:
My database have 20 tables and many users. I wish to store encrypted
data in 3 tables and have only 3 users have access to them, walking
into tables or using forms.

Can someone point me a direct help or something to read?

Tnx
Nico


Read the security faq:

http://support.microsoft.com/default...93&Product=acc

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Nov 13 '05 #2

P: n/a
MGFoster <me@privacy.com> wrote in message news:<wM*****************@newsread2.news.pas.earth link.net>...
Nico wrote:
My database have 20 tables and many users. I wish to store encrypted
data in 3 tables and have only 3 users have access to them, walking
into tables or using forms.

Can someone point me a direct help or something to read?

Tnx
Nico


Read the security faq:

http://support.microsoft.com/default...93&Product=acc


Tnx, I know it but doesnt solve. My needs are different:

- data always encrypted in some tables;
- some users may access in clear from forms, some others have no
access to clear format or access to encoded/encrypted format

Nico
Nov 13 '05 #3

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

What database engine are you using? Encrypting an Access/JET db
encrypts all the tables in the db. You might be able to link to an
encrypted db and to an unencrypted db. Once the tables are encrypted,
only users w/ permissions can read (translate to clear text) the data.

Users can be assigned access to separate tables, queries, forms,
reports. You designate who gets what in the Tools > Security > User and
Group Permissions menu item.

It would seem that you'd grant permission to the users you want to
"access in clear" and deny permission (not grant access) to users who
"have no access to clear format."

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQSpkBIechKqOuFEgEQLDigCg9tG8LTJ3wXhTEPUNqxZ5ML//kpwAn0Vw
cMZCPCXJK+07Z6Syqr/6zFeu
=CP/o
-----END PGP SIGNATURE-----

Nico wrote:
MGFoster <me@privacy.com> wrote in message news:<wM*****************@newsread2.news.pas.earth link.net>...
Nico wrote:

My database have 20 tables and many users. I wish to store encrypted
data in 3 tables and have only 3 users have access to them, walking
into tables or using forms.

Can someone point me a direct help or something to read?

Tnx
Nico


Read the security faq:

http://support.microsoft.com/default...93&Product=acc

Tnx, I know it but doesnt solve. My needs are different:

- data always encrypted in some tables;
- some users may access in clear from forms, some others have no
access to clear format or access to encoded/encrypted format

Nico


Nov 13 '05 #4

P: n/a
I'm using Access 2000 on Win XP / SP1.

I think I'm not able enough to understand your saying. I'll read the
faq you suggest me.

In the meantime you know some library or else for use encrypt/decrypt
functions in table selected data write/read?

Tnx
Nico
MGFoster <me@privacy.com> wrote in message news:<su******************@newsread1.news.pas.eart hlink.net>...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

What database engine are you using? Encrypting an Access/JET db
encrypts all the tables in the db. You might be able to link to an
encrypted db and to an unencrypted db. Once the tables are encrypted,
only users w/ permissions can read (translate to clear text) the data.

Users can be assigned access to separate tables, queries, forms,
reports. You designate who gets what in the Tools > Security > User and
Group Permissions menu item.

It would seem that you'd grant permission to the users you want to
"access in clear" and deny permission (not grant access) to users who
"have no access to clear format."

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQSpkBIechKqOuFEgEQLDigCg9tG8LTJ3wXhTEPUNqxZ5ML//kpwAn0Vw
cMZCPCXJK+07Z6Syqr/6zFeu
=CP/o
-----END PGP SIGNATURE-----

Nico wrote:
MGFoster <me@privacy.com> wrote in message news:<wM*****************@newsread2.news.pas.earth link.net>...
Nico wrote:
My database have 20 tables and many users. I wish to store encrypted
data in 3 tables and have only 3 users have access to them, walking
into tables or using forms.

Can someone point me a direct help or something to read?

Tnx
Nico

Read the security faq:

http://support.microsoft.com/default...93&Product=acc

Tnx, I know it but doesnt solve. My needs are different:

- data always encrypted in some tables;
- some users may access in clear from forms, some others have no
access to clear format or access to encoded/encrypted format

Nico

Nov 13 '05 #5

P: n/a
Better, encrypt / decrypt fields.
MGFoster <me@privacy.com> wrote in message news:<su******************@newsread1.news.pas.eart hlink.net>...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

What database engine are you using? Encrypting an Access/JET db
encrypts all the tables in the db. You might be able to link to an
encrypted db and to an unencrypted db. Once the tables are encrypted,
only users w/ permissions can read (translate to clear text) the data.

Users can be assigned access to separate tables, queries, forms,
reports. You designate who gets what in the Tools > Security > User and
Group Permissions menu item.

It would seem that you'd grant permission to the users you want to
"access in clear" and deny permission (not grant access) to users who
"have no access to clear format."

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQSpkBIechKqOuFEgEQLDigCg9tG8LTJ3wXhTEPUNqxZ5ML//kpwAn0Vw
cMZCPCXJK+07Z6Syqr/6zFeu
=CP/o
-----END PGP SIGNATURE-----

Nico wrote:
MGFoster <me@privacy.com> wrote in message news:<wM*****************@newsread2.news.pas.earth link.net>...
Nico wrote:
My database have 20 tables and many users. I wish to store encrypted
data in 3 tables and have only 3 users have access to them, walking
into tables or using forms.

Can someone point me a direct help or something to read?

Tnx
Nico

Read the security faq:

http://support.microsoft.com/default...93&Product=acc

Tnx, I know it but doesnt solve. My needs are different:

- data always encrypted in some tables;
- some users may access in clear from forms, some others have no
access to clear format or access to encoded/encrypted format

Nico

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.