Different users, different access using encrypted data

[Nico]

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

[MGFoster]

Re: Different users, different access using encrypted data

Nico wrote:
[color=blue]
> 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[/color]

Read the security faq:

http://support.microsoft.com/default.aspx?scid=kb;en-us;207793&Product=acc

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

[Nico]

Re: Different users, different access using encrypted data

MGFoster <me@privacy.com > wrote in message news:<wMRVc.928 8$3O3.3121@news read2.news.pas. earthlink.net>. ..[color=blue]
> Nico wrote:
>[color=green]
> > 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[/color]
>
> Read the security faq:
>
> http://support.microsoft.com/default...93&Product=acc[/color]

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

[MGFoster]

Re: Different users, different access using encrypted data

-----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:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQSpkBIechKq OuFEgEQLDigCg9t G8LTJ3wXhTEPUNq xZ5ML//kpwAn0Vw
cMZCPCXJK+07Z6S yqr/6zFeu
=CP/o
-----END PGP SIGNATURE-----

Nico wrote:
[color=blue]
> MGFoster <me@privacy.com > wrote in message news:<wMRVc.928 8$3O3.3121@news read2.news.pas. earthlink.net>. ..
>[color=green]
>>Nico wrote:
>>
>>[color=darkred]
>>>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[/color]
>>
>>Read the security faq:
>>
>>http://support.microsoft.com/default...93&Product=acc[/color]
>
>
> 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[/color]

[Nico]

Re: Different users, different access using encrypted data

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:<sutWc.316 36$9Y6.1169@new sread1.news.pas .earthlink.net> ...[color=blue]
> -----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:::mgf0 0 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP for Personal Privacy 5.0
> Charset: noconv
>
> iQA/AwUBQSpkBIechKq OuFEgEQLDigCg9t G8LTJ3wXhTEPUNq xZ5ML//kpwAn0Vw
> cMZCPCXJK+07Z6S yqr/6zFeu
> =CP/o
> -----END PGP SIGNATURE-----
>
> Nico wrote:
>[color=green]
> > MGFoster <me@privacy.com > wrote in message news:<wMRVc.928 8$3O3.3121@news read2.news.pas. earthlink.net>. ..
> >[color=darkred]
> >>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[/color]
> >
> >
> > 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[/color][/color]

[Nico]

Re: Different users, different access using encrypted data

Better, encrypt / decrypt fields.


MGFoster <me@privacy.com > wrote in message news:<sutWc.316 36$9Y6.1169@new sread1.news.pas .earthlink.net> ...[color=blue]
> -----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:::mgf0 0 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP for Personal Privacy 5.0
> Charset: noconv
>
> iQA/AwUBQSpkBIechKq OuFEgEQLDigCg9t G8LTJ3wXhTEPUNq xZ5ML//kpwAn0Vw
> cMZCPCXJK+07Z6S yqr/6zFeu
> =CP/o
> -----END PGP SIGNATURE-----
>
> Nico wrote:
>[color=green]
> > MGFoster <me@privacy.com > wrote in message news:<wMRVc.928 8$3O3.3121@news read2.news.pas. earthlink.net>. ..
> >[color=darkred]
> >>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[/color]
> >
> >
> > 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[/color][/color]