Permissions Change Editing Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: GrahamC (anonymous_at_discussions.microsoft.com)
Date: 07/07/04 

Date: Wed, 7 Jul 2004 13:00:02 -0700

I have a number of ACC2000 databases in a directory.
Whenever I directly open a specific database (call it DBA)
and edit any one of its tables, DBA's permissions change.
All the other databases can be edited without any changes
to their permissions.

I reset permissions at the directory level using the
Properties dialog and DBA's permissions are OK again.

I cannot see any differences between DBA and the other
databases (eg: ownership). Any thoughts?

Thanks.

Relevant Pages

  • RE: missing system.mdw file
    ... permissions to create the file, ... >The registry key is not missing. ... Running the SCAN program from the Windows ... >>| I cannot create any new databases in Access 2002 on ...
    (microsoft.public.access.setupconfig)
  • Re: one SQL DB getting info from another - user setup?
    ... It appears from your narrative that the Main and DB1 databases ... EXEC sp_helpdb 'Main' ... SQL 2000 SP3 and is turned off by default. ... > In the permissions for Main, USER1 and USER2 are listed, but have NO ...
    (microsoft.public.sqlserver.security)
  • Re: MDB remembers old MDW
    ... The workgroup file is used for a session of Access - any number of databases ... The mdw defines the usernames/passwords and group memberships. ... permissions are stored in the mdb file with the objects. ...
    (microsoft.public.access.security)
  • Re: Application roles Please Help!
    ... May I point out that with the guest account, any server login will have ... access to any db even without permissions. ... > Other databases can be accessed only via the guest user security context ...
    (microsoft.public.sqlserver.security)
  • Re: Configuring SQL 2000 for use with ESRI ArcSDE
    ... You can assign SQL Server users to database roles using sp_addrolemember: ... Permissions are entirely application specific. ... vendor for clarification of security requirements. ... I have Two databases 3 Roles ...
    (microsoft.public.sqlserver.server)