Re: How to secure an Access database.
From: david epsom dot com dot au (david_at_epsomdotcomdotau)
Date: 05/18/04
- Next message: Jan Hyde: "Re: "Unspecified error" with error code -2147467259"
- Previous message: Live_Love_Laugh: "RE: "Unspecified error" with error code -2147467259"
- In reply to: robher: "Re: How to secure an Access database."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 May 2004 10:12:10 +1000
> BTW, if this isn't the right newsgroup, ¿could you indicate which is?
No, I'm really stretching here. I read about this stuff sometimes, but it
never gets discussed here.
>but isn't it standard practice to grant physical access to a database only
through the application?
1) SQL Server has integrated security with Windows Login. Access/Jet does
not.
2) You already know how to grant physical access to the database only
through the application: your question now is how to merge the permissions
of the User with the permissions of the Role. Even with SQL Server, role
based permissions don't work as well as they should.
3) Yes, there is an API for granting additional permissions to a Program,
but I don't know any more than that it exists.
(david)
"robher" <anonymous@discussions.microsoft.com> wrote in message
news:9D8A3F8E-5FF9-4D71-B9A4-E2988E7AB00A@microsoft.com...
> Ok, granted that creating a multi-threaded application and handling all
the inter-thread communication might be a bit of an overshoot here.
>
> However, I could live with an application that runs with both users'
permissions. Couldn't that be done? I'm no expert on the matter, but isn't
it standard practice to grant physical access to a database only through the
application?
>
> BTW, if this isn't the right newsgroup, ¿could you indicate which is?
>
> Thanks again.
>
>
> ----- david epsom dot com dot au wrote: -----
>
> Ok, so you use impersonation or create two processes: one as
> dbUser, one as Login User. Now, you have to communicate between
> those two processes. There are a number of ways of communicating
> between separate processes: memory, file system, messages,
> semaphores: None of which you are going to learn about in
> vb.database.ado :~(
>
- Next message: Jan Hyde: "Re: "Unspecified error" with error code -2147467259"
- Previous message: Live_Love_Laugh: "RE: "Unspecified error" with error code -2147467259"
- In reply to: robher: "Re: How to secure an Access database."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
