Re: silly question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jack MacDonald (jackMACmacdonald_at_telus.net)
Date: 09/25/04

  • Next message: Susan L: "Corrupted Workgroup Info file" 
    Date: Sat, 25 Sep 2004 13:51:08 GMT

    On Fri, 24 Sep 2004 09:01:57 -0700, Shanin
    <Shanin@discussions.microsoft.com> wrote:

    >I've been reading all this security stuff on how to secure a database and
    >have read about problems of the owner of the object, etc. If I'm
    >understanding this correctly, when they are talking about the owner and it
    >having irrevocable rights so you don't want it to be the Admin, are they
    >referring that a person who has Admin rights on the Windows operating system
    >should not create the database because then there would be no way to
    >completely secure it or are they referring to the Admin account in Access
    >that is the default log in when you open it??

    No - Admin is the default user in Access' userlevel security system.
    It has no relation to the user account on your Windows OS, whether or
    not that user has adminstration permissions on the computer.

    I have a paper that may help with your understanding how security work
    on the website in my signature.

    >
    >If my understanding is correct, I created a database on our server, I'm not
    >an Admin user on our operating system, so it would have assigned my log in
    >info as the owner to the entire database correct?
    >
    >Another thing, I've seen all the codes and such for disabling the shift key,
    >and the program that will disable and enable, if it's not secure. I've
    >already set up user-level security so I can't use that program unless I
    >import the data to another database. I've seen the other code but am unsure
    >of where to put it since I've seen put it in another database, intermediate
    >window, etc. Also, is that just a cut and past thing or do you need to
    >change variable (where), and can you use it if your database is secure?
    >

    **********************
    jackmacMACdonald@telusTELUS.net
    remove uppercase letters for true email
    http://www.geocities.com/jacksonmacd/ for info on MS Access security

  • Next message: Susan L: "Corrupted Workgroup Info file"

    Relevant Pages

    • Re: unknown database owner
      ... cleared for the 'Admin' user. ... the "owner is unknown" (you described ... An old database, ... Rick Brandt, Microsoft Access MVP ...
      (microsoft.public.access.security)
    • RE: Access 97 Security issue Cant make a MDE
      ... "If the database is secured using user-level security, ... logged in as the owner of the database, or at least a member of the Admins ... > the dayabase as a user AND can sign in simply as admin, ... > that the user account has Modify Design or Administer permissions for the ...
      (microsoft.public.access.security)
    • Re: User Level Security Malfunction
      ... The person who logged on to Access when the database was created is the owner. ... If you are listed as the owner, you created the database while logged on as yourself, not as Admin. ... Are you opening the database by way of a shortcut that includes the path to the Security.mdw file, or have you changed the default mdw file on your installation of Access? ...
      (microsoft.public.access.security)
    • Re: Workgroup files and new domain
      ... Copy all objects from the database into a new database and You will be the ... You don't want Admin to be the owner. ... When I tried to setup the new perms in a new workgroup file, ...
      (microsoft.public.access.security)
    • Knowledge Base Article - 815154 Configure SQL Server Security for .NET Applications
      ... I get through this article and come to a dead stop not understanding ... Click Permissions ... Do I as the admin have to check each and every object one at a time? ... Do I as the admin have to do all of these steps to each and every database ...
      (microsoft.public.sqlserver.security)