How do I let users create databases and only let them delete their own?

From: Michael Fong (michael.fong_at_nospam.none.nt.gov.au)
Date: 04/29/03

  • Next message: Johan: "Re:How do I audit insert/delete/update etc" 
    Date: Tue, 29 Apr 2003 16:53:11 +0930

    Hi there,

    I have a user who I have granted the "Database Creators" Server Role, but
    with this they
    can delete or modify any database they want.

    I want the user to create and then only be alloed to delete and modify thier
    own databases ( ie only if they are the dbo )

    Any idea on how I can do this,

    Cheers,

    Michael

  • Next message: Johan: "Re:How do I audit insert/delete/update etc"

    Relevant Pages

    • Re: Shared v. Exclusive Access
      ... Control Panel, Add/remove programs, find Adobe, click Modify -> create Adobe ... The folder wherein the frontend resides grants Full permissions to the ... When I open the database, however, I don't get the message boxes. ...
      (microsoft.public.access.security)
    • Re: What is wrong or missing if I cant modefy an exisiting workgroup?
      ... 1)I wasn't able to remove admins group form User Admin. ... database and managed to modify the existing newsystem.dmw. ... Allthough I found an application that had security ...
      (microsoft.public.access.security)
    • Re: Multiple users on an Access database
      ... I think version 97 was the last one that allowed you to modify objects while someone else was using the mdb - not any more. ... I've split the database however I'm still encountering problems. ... design of a Report or Form the following message appears " Microsoft ... Access can't save design changes or save to a new database object because ...
      (microsoft.public.access.security)
    • Re: Backend Ldb file
      ... the network rights are EXACTLY the problem. ... work as intended, all users should have Create, Modify, and Delete rights as ... If a user cannot create the LDB, ... > in the database on the previous day, but is not at work on ...
      (microsoft.public.access.setupconfig)
    • Re: Creating a custom field in Project Server
      ... the number fields in Project are present in the SQL database. ... Modify or develop a table to accept the data. ... For project information and macro examples visit ...
      (microsoft.public.project)