Re: question ... query and filtering
From: Andy_HR (andy_no_spam_at_xnet.hr)
Date: 04/05/04
- Next message: B. Baixo: "Re: export query - vba"
- Previous message: Gary Walter: "Re: Drop Primary Key with SQL/VBA"
- In reply to: MGFoster: "Re: question ... query and filtering"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 5 Apr 2004 09:49:19 +0200
"MGFoster" <me@privacy.com> wrote in message
> If the data is stored on SQL Server you can create user accounts on SQL
> Server. Open Enterprise Manager and look at the Security node under the
> database tree. Set up SQL Server to use NT logon info and set your
> Connection string to include the parameter "Trusted_Connection=Yes" (and
> remove any Pwd=???;UID=??? parameters). Use the User_Name() or
> User_ID() functions to get the name/id of current-session user. Don't
> allow any user direct access to tables. Use database Roles to assign
> access thru Views. Consider using SQL'r temp tables thru stored
> procedures instead of local make-table queries.
>
> Read the Access security FAQ whitepaper for general info on applying
> security to databases:
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;165009&Product=acc
>
i would but for now i cant... it will be possible in 2 months but for now..
it is not.. becouse some users are running under guest account.. and the
complete network is going to be built from the scratch.. so i have to use
this way off doing it...
-
andy
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.650 / Virus Database: 416 - Release Date: 04.04.2004
- Next message: B. Baixo: "Re: export query - vba"
- Previous message: Gary Walter: "Re: Drop Primary Key with SQL/VBA"
- In reply to: MGFoster: "Re: question ... query and filtering"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
